when I run `meltano config tap-snowflake test` it ...
# troubleshooting
a
when I run
meltano 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_WAREHOUSE
2024-04-05T163707.430783Z [info ] The default environment 'dev' will be ignored for
meltano 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 closed
Not sure why the configuration is invalid, though
I figured this out and it is working now.
🙌 1