BigQuery Resourse does not fetch full schema with more than 5000 tables

  • Goal: I am trying to bulk insert records to BigQuery table via GUI mode.

  • Steps:

    • Add resource query block
    • Select BigQuery resource
    • Search for desired table
  • Details: The schema for given BigQuery resource contain more than 5000 tables. Table I need to insert records to starts from letter w. Retool UI only shows first 5000 tables. Search by typing in the table field seems local in the browser — does not fetch new resutls. Regular SQL mode works okay — I can query / access the table via Resource query SQL mode.

  • Screenshots: