SQL transformations in Nekt combine the power and familiarity of SQL with our intuitive interface to help you build and deploy data pipelines efficiently. Whether you’re performing complex data transformations, aggregations, or joins, our SQL Explorer provides all the tools you need while maintaining the simplicity and readability that SQL is known for.

​
Creating SQL Transformations

Nekt makes it simple to create, test, and deploy transformations using our SQL Explorer. Whether you’re writing simple queries or complex data transformations, our interface provides the tools you need to build and validate your SQL code.

​
Step 1: Access the SQL Explorer

You can access the SQL Explorer in two ways:
  1. Navigate to the Explorer page in Nekt.
  2. Go to Transformations > Add Transformation > SQL
Once you’re in the SQL Explorer, you’ll find a clean, intuitive interface where you can write and test SQL queries. The Explorer provides access to all your available data tables and views. Open SQL Explorer

​
Step 2: Build Your SQL Query

You have two options for building your query:
  1. Write SQL Manually:
    • Use the SQL editor to write your query from scratch
    • Leverage auto-completion and syntax highlighting
    • Access table schemas and column information directly in the interface
  2. Use AI Assistance:
    • Describe what you want to achieve in natural language
    • Let our AI help you generate the appropriate SQL query
    • Review and modify the generated query as needed
Best Practices:
  • Start with simple queries and build complexity gradually
  • Test your query results before creating a transformation
  • Use the query history to reference and modify previous queries

​
Step 3: Create a Transformation

Once your SQL query is working as expected:
  1. Click the “Create Transformation” button in the Explorer
  2. Configure the transformation settings:
    • Set a name and description
    • Choose when the transformation should run
    • Configure any necessary parameters
  3. Save the transformation to make it available for execution
The transformation will now be available in your transformations list, where you can:
  • Edit the SQL query directly
  • Modify the schedule and settings
  • Monitor execution history and performance
View Transformations

​
Best Practices

  1. Query Optimization:
    • Use appropriate indexes and joins
    • Limit the data processed to only what’s necessary
    • Consider query performance and resource usage
  2. Maintainability:
    • Use clear, descriptive names for transformations
    • Document complex queries with comments
    • Break down complex transformations into smaller, manageable queries
  3. Testing:
    • Always test queries with sample data first
    • Verify results match your expectations
    • Check for edge cases and data quality issues
  4. Monitoring:
    • Review transformation execution logs
    • Monitor query performance
    • Set up alerts for failed transformations

​
Need Help?

If you need assistance with SQL transformations, our team is here to help. You can:
  • Check our SQL documentation for reference
  • Use the AI assistant in the Explorer for query help
  • Contact our support team for additional guidance