Automatically Generate ER Diagrams for Your dbt Models with dbt-model-erd
Overview Not enough teams focus on conceptual modeling of data before creating dbt models. Even fewer maintain …
Query to find service name
This article explains the steps to find the service name of a database running on your local windows machine.
Open command prompt in your windows machine and issue below command, This should connect to your local database as SYSDBA
sqlplus / AS SYSDBA
Once you are connected to the database issue below command to see the service name of the database.
show parameter service\_name
Alternatively you can also open services in your windows machine and look for OracleSerrvice as show below
Comments
Related Articles
Automating Snowpipe Deployment with dbt
Overview Snowpipe is Snowflake’s most cost-efficient method for continuous data ingestion, automatically loading …