Apoorva
01/16/2023, 8:20 PMjames truty
01/17/2023, 1:23 AMsource-quickbooks
oauth flow defined here: https://github.com/airbytehq/airbyte/blob/e4bb0b927415128a5d0519398b844955af6f3732[…]/src/main/java/io/airbyte/oauth/OAuthImplementationFactory.java? There is a source-quickbooks-singer
, but no source-quickbooks
that I can see to get the consent url for exampleGanpat Agarwal
01/17/2023, 7:16 AMThéo
01/17/2023, 9:11 AMAndrzej Lewandowski
01/17/2023, 9:39 AMYogic Wahyu
01/17/2023, 10:18 AM0.39.1-alpha
and will upgrade into latest one, 0.40.28
(using docker deployment). I found that there are some cases which need to be considered like docker version, old airbyte configuration, and table migration. Do you guys have some tips for this case (I am afraid it will corrupt the existing pipelines and we have to start from scratch again)
https://docs.airbyte.com/operator-guides/upgrading-airbyte/#resetting-your-configuration
*NB, I am trying to simulate the upgrade mechanism in local machine (Mac OS BigSur), then I will do the production one (in GCP VM Ubuntu) when I am sure enough.Aleksandar
01/17/2023, 10:24 AMSELECT relname, relacl FROM pg_class WHERE relname = 'my_table';
relname | relacl
-----------------------+--------
my_table |
although my_user has read permission, once I manually give permission to my_user to read all tables
SELECT relname, relacl FROM pg_class WHERE relname = 'my_table';
relname | relacl
-----------------------+-----------------------------------------------------------------------------------
my_table | {airbyteuser=arwdDxt/airbyteuser,"\"my_user\"=r/airbyteuser"}
(1 row)
I can see the table, but ONCE I do sync
again the story repeats.
Is there way to avoid this?Aryan Garg
01/17/2023, 12:05 PMThilagar KR
01/17/2023, 12:30 PMmysql
connector as my source by establishing SSL connection
None of the push buttons r working for me...where to start debugging this?Benjamin Kassentoft
01/17/2023, 12:43 PMpackages-install-path: ../dbt
but it still fails. Is there a config somewhere where I need to define the profile
My transformations doesn't contain any special arguments just deps followed by another transformation to run
Any help would be much appreciatedJan Wilczak
01/17/2023, 2:10 PMairbyte-server
I am getting the same error. I've added one extra node, but it didn't help. I'm using kubectl apply -k kube/overlays/stable
Any idea what might be the issue? 🙂Ailton Silva
01/17/2023, 2:56 PMAilton Silva
01/17/2023, 3:05 PMAilton Silva
01/17/2023, 3:05 PMAilton Silva
01/17/2023, 3:06 PMPedro Andrade
01/17/2023, 3:46 PMFrancisco Viera
01/17/2023, 3:57 PMihsan islam
01/17/2023, 4:19 PMAntoine Meunier
01/17/2023, 4:35 PM<s3://my-bucket/some-path/dataset1-2023-01-17.csv>
for today, etc). As you probably know, I need to provide a regex to define which file(s) to pull. What I’d like to do, using the S3 connector, is to only read the file for the current day, rather than all the files present there for dataset1
(i.e. dataset1-*.csv
does not work and something like dataset1-<some_date>.csv
would work).
I thought about going incremental but since each day is a full snapshot, I think this is somewhat overkill and the “state” does not make sense in that situation.
Is there a way to achieve this with Airbyte and the S3 connector ? Let me know if there’s any additional detail I can provide.
Thanks!Mateusz Kijewski
01/17/2023, 5:47 PMairbyte-connector-builder-server
?Justen Walker
01/17/2023, 5:53 PMThilagar KR
01/17/2023, 6:51 PMEduardo lopes
01/17/2023, 7:16 PMGabriel Evangelista
01/18/2023, 12:28 AMdocker compose up
and at the end I have a problem, because I have other services running in the port 8000. I would like to know wich files I need to change port 8000 to another port. The error belowAnand Zaveri
01/18/2023, 4:59 AMAlvin Khaled
01/18/2023, 5:16 AM2023-01-18 03:35:27 normalization > Database Error in model monthly_bank_account_balance_by_workspace_stg (models/generated/airbyte_incremental/accounting_metrics/monthly_bank_account_balance_by_workspace_stg.sql)
2023-01-18 03:35:27 normalization > cannot delete from table "monthly_bank_account_balance_by_workspace_stg" because it does not have a replica identity and publishes deletes
2023-01-18 03:35:27 normalization > HINT: To enable deleting from the table, set REPLICA IDENTITY using ALTER TABLE.
2023-01-18 03:35:27 normalization > compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/accounting_metrics/monthly_bank_account_balance_by_workspace_stg.sql
Renato Todorov
01/18/2023, 7:22 AMcheck_connection
calls are retuning a "upstream request timeout" error and I'm currently not able to understand where is it coming from because there are absolutely no errors in the logs, even with DEBUG enabled. I've logged an issue here, any help is appreciated: https://github.com/airbytehq/airbyte/issues/20963. Can anyone tell me how can I further debug this issue? I've exec'd into the server container and it can communicate and connect to all the other hosts (temporal and webapp, for example). I'm stuck and have no idea how to debug it further.Mihály Dombi
01/18/2023, 9:31 AMtransactions
, first it fetches orders
and they are both incremental reads.
What I would like to know if there are any connectors at airbyte right now which fetches the parent stream incrementally, but after that fetches the child stream with full refresh.
Thank you in advance.Manish Tomar
01/18/2023, 10:20 AMAnurag Jain
01/18/2023, 10:25 AM