Andrew Abdalla
04/05/2024, 4:44 PMmeltano config tap-snowflake test
it just runs and not sure if it will ever complete. The schema specified in the meltano.yml file only has 2 tables. Here is the contents of the .yml file
version: 1
default_environment: dev
project_id: 09d664f3-5612-4911-bd86-a261d7403bc8
environments:
- name: dev
- name: staging
- name: prod
plugins:
extractors:
- name: tap-smoke-test
variant: meltano
pip_url: git+https://github.com/meltano/tap-smoke-test.git
config:
streams:
- stream_name: animals
input_filename:
https://gitlab.com/meltano/tap-smoke-test/-/raw/main/demo-data/animals-data.jsonl
- name: tap-snowflake
variant: meltanolabs
pip_url: meltanolabs-tap-snowflake
config:
account: mpa55019.us-east-1
database: PC_FIVETRAN_DB
role: SYSADMIN
schema: INTERNAL_REPORT
user: aabdalla
warehouse: PC_FIVETRAN_WH
loaders:
- name: target-snowflake
variant: meltanolabs
pip_url: meltanolabs-target-snowflake
config:
account: mpa55019.us-east-1
database: MELTANO_DATABASE
default_target_schema: MELTANO_SCHEMA
role: MELTANO_ROLE
schema: INTERNAL_REPORT
user: aabdalla
warehouse: MELTANO_WAREHOUSEAndrew Abdalla
04/05/2024, 5:02 PMmeltano config
. To configure a specific environment, please use the option --environment=<environment name>
.
2024-04-05T163707.467528Z [warning ] kind: password
is deprecated for setting definitions in favour of sensitive: true
, and is currently in use by the following settings of extractor 'tap-snowflake': 'password'. Please open an issue or pull request to update the plugin definition on Meltano Hub at https://github.com/meltano/hub/blob/main/_data/meltano/extractors/tap-snowflake/meltanolabs.yml.
Need help fixing this problem? Visit http://melta.no/ for troubleshooting steps, or to
join our friendly Slack community.
Plugin configuration is invalid
snowflake.connector.errors.DatabaseError: 250002 (08003): None: Connection is closedAndrew Abdalla
04/05/2024, 5:03 PMAndrew Abdalla
04/05/2024, 8:33 PM