Skip to main content

Oracle Connection

Examples​

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

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.

PropertyDefaultTypeRequiredDescription
descriptionstring
NoA brief description of what the model does.
metadataNoMeta information of a resource. In most cases it doesn't affect the system behavior but may be helpful to analyze project resources.
namestringYesThe name of the model
ssh_tunnelstring
No
oracleYesOracle server Connection options.

Property Details​

Connection​

Data source/sink Connection.

PropertyDefaultTypeRequiredDescription
connectionOne of:
  S3Connection
  GcsConnection
  AbfsConnection
  LocalFileConnection
  SnowflakeConnection
  BigQueryConnection
  MSSQLConnection
  MySQLConnection
  OracleConnection
  PostgresConnection
  HttpConnection
  DuckDBConnection
  SFTPConnection
  DatabricksConnection
YesData system Connection.

OracleConnectionOptions​

PropertyDefaultTypeRequiredDescription
hoststring
NoOracle server host to connect to.
userstringNoOracle server user to connect as.
passwordstringNoOracle server password to use for the Connection.
port1521integerNoOracle server port to connect to.
databasestring
NoOracle database name, used to construct a DSN if provided.
sidstringNoUnique name Oracle instance name, used to construct a DSN if provided.
service_namestringNoOracle service name, used to construct a DSN if provided. Only one of database and service_name should be provided.
dsnstringNoOracle 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.

PropertyDefaultTypeRequiredDescription
sourceNoThe origin or source information for the resource.
source_event_uuidstring
NoUUID of the event that is associated with creation of this resource.

ResourceLocation​

The origin or source information for the resource.

PropertyDefaultTypeRequiredDescription
pathstringYesPath within repository files where the resource is defined.
first_line_numberinteger
NoFirst line number within path file where the resource is defined.