Explore your data with Nekt
Sources
and verify in the Catalog
which data is being extracted into the tables.
Use the Preview
feature within each table in the Catalog to understand the data format, as this can be important for more effective exploration.
Using the AI assistant
Creating your own SQL code
Save query
function to save this query for future use. This will allow you to quickly access this code as many times as you want. Each time you run it, it will be executed on the most up-to-date data. It’s useful when you need an answer frequently.
3.2 Create a transformation and generate a new table
Use the Create transformation
function when you want the result of your query to become a new table in your Catalog.
It’s quite common, for example, for a table to come from the data source with more data than necessary for a specific use case or with unformatted data, which makes it harder to use. For this, your SQL code can handle these cases and generate the ideal table - which will only be created and updated in the Catalog (and become available for destinations and visualizations, for example) through a transformation.
3.3 Discard
If you’ve made a query that probably won’t be repeated and whose result doesn’t need to be stored in a table, you can simply close the query and do nothing with it. The Explorer is like a playground - feel free to explore your data and test what results you can achieve.