1
{
2
  "name": "awsathena connection",
3
  "type": "awsathena",
4
  "configuration": {
5
    "access_id": "AKIAIOSFODNN7EXAMPLE",
6
    "outputbucket": "s3://polytomic-athena-results/customer-dataset",
7
    "region": "us-east-1",
8
    "secret_access_key": "wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY"
9
  }
10
}

1
{
2
  ...
3
  "configuration": {
4
    "catalog": "awsdatacatalog",
5
    "database": "default",
6
    "query": "SELECT * FROM \"webdata\".\"impressions\"",
7
    "table": "users"
8
  }
9
}

1
{
2
  ...
3
  "target": {
4
      "configuration": {
5
        "preserve_table_on_resync": false
6
    }
7
  }
8
}

1
{
2
  ...
3
  "destination_configuration": {
4
    "advanced": {
5
        "table_prefix": "",
6
        "truncate_existing": false
7
    },
8
    "mirror_schemas": false,
9
    "schema": "public"
10
  }
11
}