Jared Rhizor (Airbyte)
user
11/11/2020, 3:04 AM2020-11-11 03:00:31 ERROR (/tmp/workspace/32/0) LineGobbler(voidCall):69 - Caused by: org.postgresql.util.PSQLException: ERROR: relation "click_performance_report_1605063619055" does not exist
user
11/11/2020, 3:04 AMCLICK_PERFORMANCE_REPORT_1605063619055
does existuser
11/11/2020, 3:04 AMuser
11/11/2020, 3:05 AMuser
11/11/2020, 3:05 AMuser
11/11/2020, 3:05 AMuser
11/11/2020, 3:07 AMuser
11/11/2020, 3:07 AMuser
11/11/2020, 3:07 AMuser
11/11/2020, 3:07 AMuser
11/11/2020, 3:08 AMuser
11/11/2020, 3:08 AMuser
11/11/2020, 3:08 AMuser
11/11/2020, 3:08 AMuser
11/11/2020, 3:09 AMuser
11/11/2020, 3:09 AMuser
11/11/2020, 3:09 AMuser
11/11/2020, 3:10 AMuser
11/11/2020, 3:10 AMuser
11/11/2020, 3:10 AMuser
11/11/2020, 3:11 AMuser
11/11/2020, 3:14 AMuser
11/11/2020, 3:14 AMuser
11/11/2020, 3:14 AMuser
11/11/2020, 3:15 AMuser
11/11/2020, 3:15 AMuser
11/11/2020, 3:15 AMhttps://user-images.githubusercontent.com/6246757/98760749-c5716700-2388-11eb-9b1d-d58cfde9575f.png▾
user
11/11/2020, 3:15 AMuser
11/11/2020, 3:15 AMuser
11/11/2020, 3:16 AMuser
11/11/2020, 3:19 AMuser
11/11/2020, 3:19 AMuser
11/11/2020, 3:19 AMuser
11/11/2020, 3:19 AMuser
11/11/2020, 3:20 AMuser
11/11/2020, 3:20 AMuser
11/11/2020, 3:21 AMuser
11/11/2020, 3:21 AMuser
11/11/2020, 3:21 AMuser
11/11/2020, 3:21 AMuser
11/11/2020, 3:21 AMuser
11/11/2020, 3:21 AMuser
11/11/2020, 3:21 AMuser
11/11/2020, 3:22 AMuser
11/11/2020, 3:22 AMuser
11/11/2020, 3:22 AMuser
11/11/2020, 3:22 AMuser
11/11/2020, 3:23 AMuser
11/11/2020, 3:23 AMuser
11/11/2020, 3:23 AMuser
11/11/2020, 3:23 AMuser
11/11/2020, 3:23 AMuser
11/11/2020, 3:24 AMuser
11/11/2020, 3:24 AMuser
11/11/2020, 3:24 AMuser
11/11/2020, 3:25 AMuser
11/11/2020, 3:25 AMuser
11/11/2020, 3:25 AMuser
11/11/2020, 3:25 AMuser
11/11/2020, 3:26 AMaBc
and ABc
streams?user
11/11/2020, 3:27 AMuser
11/11/2020, 3:27 AMuser
11/11/2020, 3:27 AMuser
11/11/2020, 3:27 AMuser
11/11/2020, 3:28 AMuser
11/11/2020, 3:28 AMuser
11/11/2020, 3:28 AMuser
11/11/2020, 3:29 AMfooBar
and then entrypoint.py sneakily normalized it to foobar
. when foobar
is passed back the source won’t know that it’s the same thing as fooBar
.user
11/11/2020, 3:29 AMuser
11/11/2020, 3:29 AMuser
11/11/2020, 3:29 AMuser
11/11/2020, 3:29 AMuser
11/11/2020, 3:29 AMuser
11/11/2020, 3:30 AMuser
11/11/2020, 3:30 AMuser
11/11/2020, 3:30 AMuser
11/11/2020, 3:30 AMuser
11/11/2020, 3:30 AMuser
11/11/2020, 3:30 AMuser
11/11/2020, 3:31 AMuser
11/11/2020, 3:31 AMuser
11/11/2020, 3:31 AMuser
11/11/2020, 3:32 AMuser
11/11/2020, 3:32 AMuser
11/11/2020, 3:32 AMuser
11/11/2020, 3:32 AMuser
11/11/2020, 3:32 AMuser
11/11/2020, 3:33 AMuser
11/11/2020, 3:33 AMuser
11/11/2020, 3:33 AMuser
11/11/2020, 3:33 AMuser
11/11/2020, 3:33 AMuser
11/11/2020, 3:33 AMuser
11/11/2020, 3:33 AMuser
11/11/2020, 4:28 PMuser
11/11/2020, 4:28 PMuser
11/11/2020, 4:29 PMuser
11/11/2020, 4:31 PMuser
11/11/2020, 4:32 PMuser
11/11/2020, 4:33 PMuser
11/11/2020, 4:34 PMuser
11/11/2020, 4:34 PMuser
11/11/2020, 4:35 PMuser
11/11/2020, 4:35 PMuser
11/11/2020, 4:36 PMuser
11/11/2020, 4:36 PMuser
11/11/2020, 4:52 PMPre release we can add quoting to identifiers in the Postgres destination tooThat's what i end up doing in the normalization pieces by DBT with the default
quoting
parameters set to true in the sources.yml file but we can actually play with those settings to disable quoting or not...user
11/11/2020, 5:17 PMuser
11/11/2020, 5:59 PMuser
11/11/2020, 5:59 PMuser
11/11/2020, 6:00 PMuser
11/11/2020, 6:05 PMuser
11/11/2020, 6:12 PMException in thread "main" org.jooq.exception.DataAccessException: SQL [insert into streamWithCamelCase_1605118306833 (ab_id, data, emitted_at) values (?, cast(? as jsonb), cast(? as timestamp with time zone))]; ERROR: relation "streamwithcamelcase_1605118306833" does not exist
user
11/11/2020, 6:12 PMuser
11/11/2020, 6:17 PMuser
11/11/2020, 6:27 PMuser
11/11/2020, 6:27 PMuser
11/11/2020, 6:28 PMuser
11/11/2020, 6:28 PMuser
11/11/2020, 6:28 PMuser
11/11/2020, 6:28 PM→ docker image ls airbyte/destination-postgres:0.1.1
REPOSITORY TAG IMAGE ID CREATED SIZE
airbyte/destination-postgres 0.1.1 2d00d190bca9 28 minutes ago 440MB
user
11/11/2020, 6:29 PMuser
11/11/2020, 6:29 PMuser
11/11/2020, 6:33 PMuser
11/11/2020, 6:33 PMuser
11/11/2020, 6:34 PMuser
11/11/2020, 6:35 PMuser
11/11/2020, 6:35 PMuser
11/11/2020, 6:35 PMuser
11/11/2020, 6:35 PMuser
11/11/2020, 6:35 PMuser
11/11/2020, 6:36 PMBy default, jOOQ will always generate quoted names for all identifiers
user
11/11/2020, 6:37 PMuser
11/11/2020, 7:07 PMfield*name*with*asterisk*
or is that overkill for right now?user
11/11/2020, 7:07 PMuser
11/11/2020, 7:08 PMuser
11/11/2020, 7:08 PMsuper$nonstandard!@
user
11/11/2020, 7:08 PMuser
11/11/2020, 7:08 PMuser
11/11/2020, 7:08 PMuser
11/11/2020, 7:08 PMuser
11/11/2020, 7:08 PMuser
11/11/2020, 7:08 PMuser
11/11/2020, 7:09 PMuser
11/11/2020, 7:09 PMuser
11/11/2020, 7:09 PMuser
11/11/2020, 7:09 PM_
user
11/11/2020, 7:10 PMx$*y == x*$y
user
11/11/2020, 7:10 PMuser
11/11/2020, 7:10 PMuser
11/11/2020, 7:10 PMuser
11/11/2020, 7:10 PMuser
11/11/2020, 7:11 PMuser
11/11/2020, 7:11 PMuser
11/11/2020, 7:11 PMuser
11/11/2020, 7:12 PMuser
11/11/2020, 7:15 PMuser
11/11/2020, 7:15 PMuser
11/11/2020, 7:23 PMuser
11/11/2020, 7:23 PMuser
11/11/2020, 7:23 PM