Hey all I just set up a sync job on 0 39 18 alpha My source | Advice-data-transformation

Hey all - I just set up a sync job on 0.39.18-alpha. My source is Facebook Marketing 0.2.51 and my destination is Postgresql 0.3.20. Unfortunately the connection errors out with the following issue:

function json_extract_array(jsonb, unknown) does not exist

Which makes sense, given that that function doesn't exist in postgresql (at least not on version 12, which is the database version). How can I get this working?

5:45 PM

logs-3.txt

Marcos Marx (Airbyte)

06/15/2022, 5:52 PM

Status:  403
  Response:
    {
      "error": {
        "message": "(#200) Requires business_management permission to manage the object",
        "type": "OAuthException",
        "code": 200,
        "fbtrace_id": "ASgzo24jTvb53U2oKGxt20l"
      }
    }

5:53 PM

The normalization error is mislead, you had an error before getting the fb data

Collin Rincon Scangarella

06/15/2022, 5:53 PM

Gotcha. Thank you Marcos

View count: 1

Join thread in Slack