トラブルシューティングとベストプラクティス

Test grants failed, cause: user is missing the required grants on *.*: ALTER, CREATE DATABASE, CREATE TABLE, INSERT, SELECT

GRANT CURRENT GRANTS ON *.* TO fivetran_user;

error while waiting for all mutations to be completed: ... initial cause: ...

columns count in ClickHouse table (8) does not match the input file (6). Expected columns: id, name, ..., got: id, name, ...

column user_email was not found in the table definition. Table columns: ...; input file columns: ...

code: 168, message: AST is too big. Maximum: 50000

code: 62, message: Max query size exceeded

code: 241, message: (total) memory limit exceeded: would use 14.01 GiB

ClickHouse connection error: unexpected EOF

cause: can't map type UInt64 to Fivetran types

Failed to alter table ... cause: no primary keys for table

user is missing the required grants on *.*: ALTER, CREATE DATABASE, CREATE TABLE, INSERT, SELECT

SELECT access_type, database, table, column FROM system.grants WHERE user_name = 'my_user'

GRANT CURRENT GRANTS ON *.* TO fivetran_user;

SELECT * FROM schema.table FINAL WHERE ...

SELECT event_time, query, exception_code, exception
FROM system.query_log
WHERE client_name LIKE 'fivetran-destination%'
  AND exception_code > 0
ORDER BY event_time DESC
LIMIT 50;

SELECT event_time, query_kind, query, exception_code, exception
FROM system.query_log
WHERE user = '{fivetran_user}'
ORDER BY event_time DESC
LIMIT 100;