We all know it's really hard to get good pricing and cost information.
Please share what you can so you can help your peers.
You pay as you go, and you don't pay for services that you don't use. If you feel that you need additional resources then you can increase them and pay only for them. There is no need to worry about paying for something that you don't use. Licensing depends also on how you want to store your data. For example, some clients use a hybrid approach, where some data is stored on the cloud and other data is stored on-premises. Overall, I think that the price is quite cheap, and they gave me a $300 credit.
I don't handle the billing or licensing aspect of the solution. I don't have any insights into the cost of the product or how many licenses the company holds.
Licensing costs are typically arranged by Oracle CPU. You pay for the access and then you can scale. If you have a fairly intensive database activity, you'd scale up by CPU, and you're paying by the CPU and the uptime. So there's a marginal uptime cost. If your operations are only running 12 hours a day, you can put your database offline after that and reduce costs. If you had multiple databases supporting the same environment, let's say a development, a test, and a production, you could just turn off the development and the test when you're not fixing anything or developing, and that would reduce your costs. There is also a free version of ADW that can be accessed if you create a cloud account. I think it allows for 20MB of space that is free.
Please share with the community what you think needs improvement with Oracle Autonomous Data Warehouse.
What are its weaknesses? What would you like to see changed in a future version?
I am a solution architect for a global tech company with over ten years of experience.
What are the benefits of having separate layers or a dedicated schema for each layer in ETL?
One dedicated layer for staging, one for type 1 persistent tables, and a dedicated schema/layer for tables at a dimensional model?
Why it is not recommended to have all tables in one schema?
I appreciate your help.