Active IQ Unified Manager Discussions

OCI DWH 7.3 How to create a custom view/table

INGO_REPINZ

Hello,

 

until verison 7.2.x in the DWH was a database called 'test', that I could use to create custom tables and views.

Since 7.3 this database is gone, but the dwh_custom-database was introduced.

 

But there I can not create a view or table. Did some how I could recreate the tables/views I've used to simplify some queries.

 

I use the default-user, dwhuser.

 

 

Any hint would be welcome.

 

Best Regads

Ingo

cheers Ingo
1 ACCEPTED SOLUTION

ostiguy

I believe the best practice is to be using the "dwh"user account for any RW activities to dwh_custom. The dwhuser account is purely read only,and thus your inability to use it to create views is expected behavior

 

Matt

View solution in original post

1 REPLY 1

ostiguy

I believe the best practice is to be using the "dwh"user account for any RW activities to dwh_custom. The dwhuser account is purely read only,and thus your inability to use it to create views is expected behavior

 

Matt

View solution in original post

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public