Loading limited data from drill connection

General
, , , ,
#1

Hello Helical team,

I am using helical insight 4.1 GA. I am connecting drill. However I would like to load only limited schema data so that the metadata creation page is faster. How can that be done.
I referred to this blog but it of not much help : Restrict Tables, Catalog, Schema Exposed At Metadata Via URL

Thank You,
Netta.

#2

Hello Netta,

The above blog which you are referring, based on the db you are connecting the syntax might change slightly since every db has its own connection URL requirements.

When we make connect to Apache drill , in order to filter out required schema you can add the below syntax. It helps to ignore unwanted schema to be loaded and improves performance.

We can write the syntax as below :

HI_DATABASE
jdbc:drill:drillbit=localhost:31010;?HI_DATABASE=dfs.default

HI_CATALOG
jdbc:drill:drillbit=localhost:31010;?HI_CATALOG=dfs.default

HI_SCHEMA
jdbc:drill:drillbit=localhost:31010;?HI_SCHEMA=dfs.default

HI_TABLE
jdbc:drill:drillbit=localhost:31010;?HI_TABLE=primer-dataset.json

HI_DATABASE_CONTAINS
jdbc:drill:drillbit=localhost:31010;?HI_DATABASE_CONTAINS=dfs

HI_CATALOG_CONTAINS
jdbc:drill:drillbit=localhost:31010;?HI_CATALOG_CONTAINS=dfs

HI_SCHEMA_CONTAINS
jdbc:drill:drillbit=localhost:31010;?HI_SCHEMA_CONTAINS=dfs

HI_TABLE_CONTAINS
jdbc:drill:drillbit=localhost:31010;?HI_TABLE_CONTAINS=primer

Combine Database/Catalog/Schema with Table
jdbc:drill:drillbit=localhost:31010;?HI_TABLE=primer-dataset.json&HI_SCHEMA_CONTAINS=hi

Thank You,
Helical Team.