dylan_just
10/12/2024, 3:03 AMdylan_just
10/12/2024, 3:04 AM2024-10-12 13:00:28,981 | INFO | target-clickhouse | Target 'target-clickhouse' completed reading 354 lines of input (2 schemas, 349 records, 0 batch manifests, 3 state messages).
2024-10-12 13:00:28,996 | INFO | target-clickhouse.public-practitioners | Inserting with SQL: INSERT INTO public.practitioners
(id, team_id, user_id, active, position, specialty, created_at, updated_at)
VALUES (:id, :team_id, :user_id, :active, :position, :specialty, :created_at, :updated_at)
2024-10-12 13:00:28,999 | INFO | target-clickhouse.public-forms | Inserting with SQL: INSERT INTO public.forms
(id, name, published, save_to_datacollections, available_incall, available_precall, available_presession, available_postcall, available_to_guests, platform_id, organisation_id, team_id, creation_level, created_user_id, last_modified_user_id, exportable, public_id, created_at, updated_at, deleted_at, deleted_by, app_id)
dylan_just
10/12/2024, 3:05 AMpublic.forms
.dylan_just
10/12/2024, 3:06 AMdylan_just
10/12/2024, 3:07 AMclickhouse_sqlalchemy.exceptions.DatabaseException: Orig exception: Code: 81. DB::Exception: Database public does not exist. (UNKNOWN_DATABASE) (version 24.6.2.17 (official build))
dylan_just
10/12/2024, 3:10 AMpublic-forms
into table forms
in db public
. I don't have a db called public - my db is called warehouse
and I've put that config in meltano.yml.
With I run meltanolabs target-postgres and the ticketswap target-redshift with the same data, they both store this into a table called public_forms
in a schema name derived from the tap.dylan_just
10/12/2024, 3:10 AMdylan_just
10/12/2024, 3:11 AMEdgar RamĂrez (Arch.dev)
10/14/2024, 9:55 PMdefault_target_schema
would fix this?dylan_just
10/15/2024, 10:34 AMdylan_just
10/15/2024, 10:34 AMdylan_just
10/15/2024, 10:35 AMEdgar RamĂrez (Arch.dev)
10/15/2024, 2:26 PMdatabase > table
, more similar to mysql?dylan_just
10/15/2024, 7:27 PMLesedi Kwatsherema
11/19/2024, 1:29 PMIf you have installed ClickHouse and forgot password you can reset it in the configuration file.
even if the password is correct. Is there anything am missing?
- name: target-clickhouse
variant: shaped-ai
pip_url: git+<https://github.com/shaped-ai/target-clickhouse.git>
config:
host: gptai7k7fx.us-east-1.aws.clickhouse.cloud
port: 8443
database: default
username: default
password: test
secure: true
verify: false