Your Oracle DBA must set up the following objects and permissions on Oracle. If tables you need do not appear in generated LookML or SQL Runner, try executing: EXEC DBMS_STATS.GATHER_DATABASE_STATS įor alternative methods, consult your Oracle documentation. Looker may not be able to identify tables (especially empty tables) without first collecting statistics in Oracle. If you want to access additional tables in the future, you will need to grant SELECT on those new tables as well. Next, give the new Looker user the ability to create sessions: GRANT CREATE SESSION TO LOOKER įinally, give the Looker user the appropriate SELECT permissions for the data tables you plan to access from Looker. If you're interested in using SSL encryption, see the Oracle documentation.įirst, create a designated Looker user: - connect / as sysdba Consider one of the options described on the Enabling secure database access documentation page. Looker strongly recommends encrypting network traffic between the Looker application and your database. If your Oracle database is an Oracle RAC deployment, Looker can integrate successfully but may have issues killing queries due to a difference in metadata for retrieving query connection IDs from nodes. Looker support for Oracle was implemented using traditional Oracle deployments. Save money with our transparent approach to pricing Managed Service for Microsoft Active Directory Rapid Assessment & Migration Program (RAMP) Hybrid and Multi-cloud Application PlatformĬOVID-19 Solutions for the Healthcare Industry Viewing dashboards in the Looker mobile application.Viewing Looks in the Looker mobile application.Navigating to content in the Looker mobile application.Signing in to the Looker mobile application.Installing the Looker mobile application on your mobile device.
Enabling the Looker mobile application for your instance.
0 kommentar(er)
