| Scroll ignore | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||
In the setup of some Tools (Tableau, Power BI, dbt etc) you will be required to add a Host/Database Mapping configuration. This is to link the sources in the tool to the sources that you have added to K.
The mapping provides K with information about what the data source is connected to (other data sources).
Follow the following steps when you see this step
...
Locating Host/Database name in K
Click need to map sources used by these tools to sources that are onboarded in K. Mapping allows K to resolve sources that might be named differently across different tools.
There are 2 methods for mapping
Mapping via Guided workflow: Recommended
Mapping via Configuration: Required for dbt
1. Mapping via the guided workflow
| Info |
|---|
This step is performed after the initial load. After the initial load, K will identify all the sources for you to map. |
Go to Platform Settings. Select Sources
On the tool, select the Map sources option
Select a source identified in the tool
Complete the workflow by selecting the matching database that is loaded into K
You may not be able to map all sources if they have not been loaded to K. Sources that are not loaded will be added as Understanding Reference Objects (Databases, Schema & Tables)
2. Mapping via Configuration
| Info |
|---|
This step is required for dbt. We recommend option 1 for all other Tools |
During the onboarding process, you will see the option to add mappings via a configuration
...
Find the mapping details
To find the appropriate mapping, click on Platform Settings and select Sources.
Locate the source you need to map. Sources are listed in alphabetical order.
Click on the copy icon next to the host name (under the host column) of the source you are onboarding
...
Adding the mapping
The mapping is added using properly formatted JSON.
...
For the following examples, we assume the host name in K is ab#####a Snowflake database will have a hostname like ab12345.australia-east.azure (an example of a Snowflake source host name)
For sources that use just a host (e.g. dbt)
...
Where tool-hostname is the Tool reference (like a Project ID or Data Source name) as it appears in the source, host are those that are onboarded into K already or that you intend to onboard into K. See example below for DBT which matches Project to Snowflake.
Example: dbt
...
Add an entry for each project you have in dbt cloud. The tool-hostname to use is the Project ID.
...