Oracle Connection

Examples

basic_oracle_connection.yaml

connection:
  oracle:
    host: your-hostname
    port: 1521

oracle_connection_with_auth.yaml

connection:
  oracle:
    host: your-hostname
    user: your-username
    password: ${secret.my_vault_name.oracle_password}

oracle_connection_dsn_override.yaml

connection:
  oracle:
    dsn: your-dsn
    host: your-hostname
    user: your-username
    password: ${secret.my_vault_name.your-password}

OracleConnection

info

OracleConnection is defined beneath the following ancestor nodes in the YAML structure:

• Connection

Below are the properties for the OracleConnection. Each property links to the specific details section further down in this page.

Property	Default	Type	Required	Description
name		string	No	The name of the model
description		string	No	A brief description of what the model does.
metadata		ResourceMetadata	No	Meta information of a resource. In most cases it doesn't affect the system behavior but may be helpful to analyze project resources.
oracle		OracleConnectionOptions	Yes	The Oracle server connection options.

Property Details

Connection

A connection to a data source/sink.

Property	Default	Type	Required	Description
connection		One of:   S3Connection   GcsConnection   AbfsConnection   LocalFileConnection   SnowflakeConnection   BigQueryConnection   MSSQLConnection   MySQLConnection   OracleConnection   PostgresConnection   HttpConnection   DuckDBConnection   CustomPythonConnection   SynapseConnection	Yes	The connection to the data system.

OracleConnectionOptions

Property	Default	Type	Required	Description
host		string	Yes	The Oracle server host to connect to.
user		string	No	The Oracle server user to connect as.
password		string	No	The Oracle server password to use for the connection.
port	1521	integer	No	The Oracle server port to connect to.
database		string	No	The Oracle service name if provided.
sid		string	No	The unique name of an Oracle instance, used to construct a DSN if provided.
service_name		string	No	The Oracle service name, used to construct a DSN if provided. Only one of database and service_name should be provided.
dsn		string	No	An Oracle Data Source Name. If provided, overrides all other connection arguments except username and password.

ResourceMetadata

Meta information of a resource. In most cases it doesn't affect the system behavior but may be helpful to analyze project resources.

Property	Default	Type	Required	Description
source		ResourceLocation	No	The origin or source information for the resource.
source_event_uuid		string	No	UUID of the event that is associated with creation of this resource.

ResourceLocation

The origin or source information for the resource.

Property	Default	Type	Required	Description
path		string	Yes	Path within repository files where the resource is defined.
first_line_number		integer	No	First line number within path file where the resource is defined.