curl --request POST \
  --url https://app.getcensus.com/api/v1/sources \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "connection": {
    "name": "Acme Inc. Snowflake",
    "label": "Acme Inc. Snowflake",
    "warehouse_writeback_retention_in_days": 7,
    "credentials": {
      "hostname": "<instance>.<region>.redshift.amazonaws.com,",
      "port": "5439,",
      "user": "redshift_user,",
      "password": "redshift_password,",
      "database": "demo"
    },
    "type": "snowflake",
    "sync_engine": "basic"
  }
}
'

{
  "status": "created",
  "data": {
    "id": 4,
    "name": "Acme Inc. Snowflake",
    "label": "Acme Inc. Snowflake",
    "type": "snowflake",
    "sync_engine": "basic",
    "created_at": "2023-07-22T23:42:47.239Z",
    "last_test_results": {
      "steps": [
        {
          "step": "Verify connectivity",
          "status": "success",
          "error": {
            "message": "<string>"
          }
        }
      ]
    },
    "last_test_succeeded": true,
    "last_tested_at": "2023-11-07T05:31:56Z",
    "connection_details": {
      "account": "xxxxxxx.us-east-1,",
      "user": "DEV,",
      "warehouse": "TEST,",
      "use_keypair": false
    },
    "warehouse_writeback_retention_in_days": 7
  }
}