repositories:
- namespace: CHANGEME
  repository: airbyte-mysql
  # Catalog-specific metadata for the repository. Optional.
  metadata:
    readme:
      text: Readme
    description: Description of the repository
    topics:
    - sample_topic
  # Data source settings for the repository. Optional.
  external:
    # Name of the credential that the plugin uses. This can also be a credential_id if the
    # credential is already registered on Splitgraph.
    credential: airbyte-mysql
    plugin: airbyte-mysql
    # Plugin-specific parameters matching the plugin's parameters schema
    params:
      host: ''  # REQUIRED. Host. The host name of the database.
      port: '3306' # REQUIRED. Port. The port to connect to.
      database: '' # REQUIRED. Database. The database name.
      username: '' # REQUIRED. Username. The username which is used to access the database.
      replication_method: # REQUIRED. Replication Method. Replication method to use for extracting data from the database.. Choose one of:
      -  # STANDARD. Standard replication requires no setup on the DB side but will not be able to represent deletions incrementally.
        method: STANDARD  # REQUIRED. Constant
      - # Logical Replication (CDC). CDC uses the Binlog to detect inserts, updates, and deletes. This needs to be configured on the source database itself.
        method: CDC  # REQUIRED. Constant
      normalization_mode: basic # Post-ingestion normalization. Whether to normalize raw Airbyte tables. `none` is no normalization, `basic` is Airbyte's basic normalization, `custom` is a custom dbt transformation on the data.. One of none, basic, custom
      normalization_git_branch: master # dbt model Git branch. Branch or commit hash to use for the normalization dbt project.
      jdbc_url_params: '' # JDBC URL Params. Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
      ssl: true # SSL Connection. Encrypt data using SSL.
    tables:
      sample_table:
        # Plugin-specific table parameters matching the plugin's schema
        options:
          airbyte_cursor_field: []  # Cursor field(s). Fields in this stream to be used as a cursor for incremental replication (overrides Airbyte configuration's cursor_field)
          airbyte_primary_key_field: [] # Primary key field(s). Fields in this stream to be used as a primary key for deduplication (overrides Airbyte configuration's primary_key)
        # Schema of the table, a list of objects with `name` and `type`. If set to `[]`, will infer. 
        schema: []
    # Whether live querying is enabled for the plugin (creates a "live" tag in the
    # repository proxying to the data source). The plugin must support live querying.
    is_live: false
    # Ingestion schedule settings. Disable this if you're using GitHub Actions or other methods
    # to trigger ingestion.
    schedule:
credentials:
  airbyte-mysql:  # This is the name of this credential that "external" sections can reference.
    plugin: airbyte-mysql
    # Credential-specific data matching the plugin's credential schema
    data:
      normalization_git_url: ''  # dbt model Git URL. For `custom` normalization, a URL to the Git repo with the dbt project, for example,`https://uname:pass_or_token@github.com/organisation/repository.git`.
      password: '' # Password. The password associated with the username.
      ssl_mode: # SSL modes. SSL connection modes. <li><b>preferred</b> - Automatically attempt SSL connection. If the MySQL server does not support SSL, continue with a regular connection.</li><li><b>required</b> - Always connect with SSL. If the MySQL server doesn’t support SSL, the connection will not be established. Certificate Authority (CA) and Hostname are not verified.</li><li><b>verify-ca</b> - Always connect with SSL. Verifies CA, but allows connection even if Hostname does not match.</li><li><b>Verify Identity</b> - Always connect with SSL. Verify both CA and Hostname.</li></ul>Read more <a href="https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-using-ssl.html"> in the docs</a>.. Choose one of:
      -  # preferred. Preferred SSL mode.
        mode: preferred  # REQUIRED. Constant
      - # required. Require SSL mode.
        mode: required  # REQUIRED. Constant
      - # Verify CA. Verify CA SSL mode.
        mode: verify_ca  # REQUIRED. Constant
        ca_certificate: '' # REQUIRED. CA certificate. CA certificate
        client_certificate: '' # Client certificate. Client certificate (this is not a required field, but if you want to use it, you will need to add the <b>Client key</b> as well)
        client_key: '' # Client key. Client key (this is not a required field, but if you want to use it, you will need to add the <b>Client certificate</b> as well)
        client_key_password: '' # Client key password (Optional). Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
      - # Verify Identity. Verify-full SSL mode.
        mode: verify_identity  # REQUIRED. Constant
        ca_certificate: '' # REQUIRED. CA certificate. CA certificate
        client_certificate: '' # Client certificate. Client certificate (this is not a required field, but if you want to use it, you will need to add the <b>Client key</b> as well)
        client_key: '' # Client key. Client key (this is not a required field, but if you want to use it, you will need to add the <b>Client certificate</b> as well)
        client_key_password: '' # Client key password (Optional). Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.