Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Created new version for 3.0.2
Scroll ignore
scroll-viewporttrue
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-htmltrue
scroll-epubtrue

Open in new tab

About Collectors

Collectors are extractors that are developed and managed by you (A customer of K).

...

These tables are per database in Postgres

  • pg_attributepg_class

  • pg_namespace

  • pg_proc

  • pg_database

  • pg_language

  • pg_type

  • pg_collation

  • pg_depend

  • pg_sequence

  • pg_constraint

  • pg_authid

  • pg_auth_members

Databases

  • The user must also be able to connect to all All other databases that you want onboarded

Info

Note that visibility of entries in these tables will depend on if the user has SELECT access to the table, so make sure SELECT is granted to the <kada user> for all tables within the database. You may need to re-apply this grant if schemas are dropped, you may also wish to apply a default grant on the schema so future tables can be visible.

  1. Code Block
    languagesql
    GRANT SELECT ON ALL TABLES IN SCHEMA <schema> TO <kada user>
  2. Code Block
    languagesql
    ALTER DEFAULT PRIVILEGES IN SCHEMA <schema> public GRANT SELECT ON TABLES TO <kada user>

...

Step 1: Create the Source in K

...