Oracle Connection
Examples​
- basic_oracle_connection.yaml
- oracle_connection_with_auth.yaml
- oracle_connection_dsn_override.yaml
connection:
oracle:
database: my_database
host: your-hostname
port: 1521
connection:
oracle:
database: my_database
host: your-hostname
user: your-username
password: ${vaults.my_vault_name.oracle_password}
connection:
oracle:
dsn: your-dsn
database: my_database
host: your-hostname
user: your-username
password: ${vaults.my_vault_name.your-password}
OracleConnection​
info
OracleConnection
is defined beneath the following ancestor nodes in the YAML structure:
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 |
---|---|---|---|---|
description | string | No | A brief description of what the model does. | |
metadata | No | Meta information of a resource. In most cases it doesn't affect the system behavior but may be helpful to analyze project resources. | ||
name | string | Yes | The name of the model | |
ssh_tunnel | string | No | ||
oracle | 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   SFTPConnection   DatabricksConnection | 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 | Yes | 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 | 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. |