Connections

Connection files define database connections and schemas for the repository. These are required to import fact and dimension datasets into your repository.

Each connection file should define a single database connection and its schema. If you need to use additional schemas for the same database, each must be defined in a separate connection file.

Connection files support the following properties.

unique_name

Type: string
Required: Y

A unique name for the database and the schema. This must be unique across all repositories and subrepositories.

object_type

Type: const
Required: Y

The type of object defined by this file. For connections, this value must be connection.

label

Type: string
Required: Y

The name of the database connection as it appears in AtScale. This value does not need to be unique.

as_connection

Type: string
Required: Y

The name of the database connection itself, excluding the schema.

database

Type: string
Required: Y

The source database used for this connection.

schema

Type: string
Required: Y

The source schema used for this connection.