Once you publish the data, a database connection is automatically created in the Sigma Studio in the name of _IMPORT_CONNECTION_. All the successive data that you import are created as data sources under this default connection.
| Note |
|---|
You cannot edit or modify the configurations of this imported connection and its . |
.png?version=1&modificationDate=1668058564904&cacheVersion=1&api=v2&width=900)
- Hover the mouse on the imported connection and click the Data Source
%20-%203.png?version=1&modificationDate=1668056672419&cacheVersion=1&api=v2)
icon..png?version=1&modificationDate=1668056778086&cacheVersion=1&api=v2&width=900)
In the Create Datasource screen, provide the necessary details to configure the data source.
...
And a corresponding data source is created for the new connection with a table name appended with the string _DS.
.png?version=1&modificationDate=1634762803605&cacheVersion=1&api=v2&width=900)
...
Note The excel sheet which had been imported using the Excel Import option in Studio will have a prefix of imp. Let's assume that the imported excel sheet file name is Card Summary and the Object Name lookup field lists the tables of the schema based on the provided search results. On making use of the imp prefix, the imported excel sheet in the form of a table will get listed in the Object Name field and this imported table should be selected to create the data source.
.png?version=1&modificationDate=1668058907477&cacheVersion=1&api=v2&width=900)
- Select the required data columns from the Column IDs drop-down list.
- Once you configure the data source, you can then proceed to click Save to save the data source.
.png?version=1&modificationDate=1668058937385&cacheVersion=1&api=v2&width=900)
A confirmation message appears, once the data source gets created successfully..png?version=1&modificationDate=1668059208821&cacheVersion=1&api=v2&width=306)
- Click Ok.