Features

    One platform for your entire data stack

    From AI-powered analytics to instant rollbacks, Nile gives your team the tools to move fast without breaking things.

    NileNile Studio
    ?
    Inventory Analysis×
    Product Performance×
    Store Trends×
    Customer LTV×
    Revenue Report×
    sales×

    finance.sales

    managed
    v1.main @ v1.0.14(current)
    OverviewSchemaLineageJobsVersions & BranchesDefinition
    Direction:
    Layout:
    finance / customersColumns (4)customer_idstringcustomer_namestringemailstringphonestringJobs (1)customer-generator2026-01-192026-01-182026-01-17finance / productsColumns (4)product_idstringproduct_namestringcategorystringsubcategorystringJobs (1)product-generator2026-01-192026-01-182026-01-17finance / storesColumns (4)store_idstringstore_namestringstore_typestringregionstringJobs (1)store-generator2026-01-192026-01-182026-01-17finance / salesColumns (4)transaction_idstringsale_datedatetransaction_timetimestampcustomer_idstringJobs (1)sales-generator2026-01-192026-01-182026-01-17finance / product_performanceColumns (4)report_datedateproduct_idstringproduct_namestringbrandstringJobs (1)product-aggregator2026-01-192026-01-182026-01-17finance / executive_dashboardColumns (4)report_datedateregionstringtotal_revenuedoubletotal_costdoubleJobs (1)executive-report2026-01-192026-01-182026-01-17finance / sales_by_storeColumns (4)report_datedatestore_idstringstore_namestringstore_typestringJobs (1)store-aggregator2026-01-192026-01-182026-01-17finance / sales_trendsColumns (4)report_datedateperiod_typestringtotal_salesdoubleavg_daily_salesdoubleJobs (1)sales-trends-calculator2026-01-192026-01-182026-01-17
    8 tables7 edges
    Declared (7)
    Detected (0)
    External
    ETL Codefinance.sales
    1"""
    2Self-generating sales fact table.
    3Generates 250-1000 sales transactions per job run by sampli
    4Each record is traceable via job_run_ts timestamp.
    5
    6Includes cost/margin columns needed by downstream aggregati
    7"""
    8
    9def transform_data(spark):
    10 from datetime import datetime
    11 from pyspark.sql.functions import (
    12 rand, col, expr, lit, current_timestamp, current_da
    13as floor, when, round spark_round
    14 )
    15
    16 import random
    17
    18 job_run_ts = datetime.now().isoformat()
    19
    20 # Read from upstream dimensions
    21 products = spark.table('finance.products').filter(col(
    22 customers = spark.table('finance.customers')
    23 stores = spark.table('finance.stores')
    24
    25 num_transactions = random.randint(, )2501000
    26
    27 # Sample from dimensions
    28 sampled_products = products.orderBy(rand()).limit(min(
    29 sampled_customers = customers.orderBy(rand()).limit(min
    30 sampled_stores = stores.orderBy(rand()).limit(min(, s20
    31
    32 # Cross join and sample to create transactions
    ...110 lines

    Data Lineage

    Visualize how your tables connect. Trace data flow across your entire pipeline. See dependencies, detect issues, and maintain data quality with automatic lineage tracking.

    NileNile Studio
    ?
    Revenue Ta...×
    ETL Job St...×
    Data Quali...×
    Pipeline F...×
    Schema Exp...×
    Data Fresh...×
    New Chat×
    +

    Start a conversation

    Ask your data questions, AI assistant has full knowledge of your datasets!

    Ask your data questions...

    AI Powered Analytics

    Our AI agents analyze your data, suggest visualizations, and surface hidden patterns. Ask questions in natural language and get instant answers backed by your actual data.

    NileNile Studio
    Catalog
    analytics
    feature_adoption
    feature_flags
    features
    revenue
    revenue_by_product
    revenue_trends
    user_sessions
    Ask Nile anything...

    Create new tables instantly

    Run AI analysis, save as table — instant production grade pipelines will be created for you.

    NileNile Studio

    Monthly Compute

    $7,526

    ↓ 73% YoY

    Monthly Storage

    $2,367

    ↓ 68% YoY

    Avg Cost / Metric

    $0.09

     

    Annual Savings

    $9,564

    cumulative

    Monthly Infrastructure Costs

    Compute + storage over the last 6 months

    Compute
    Storage
    $10.2k
    Oct
    $10.0k
    Nov
    $10.1k
    Dec
    $9.9k
    Jan
    $9.9k
    Feb
    $9.9k
    Mar

    Lower storage costs

    Nile stores data in open formats on your own cloud provider — no proprietary storage markup, no egress surprises. Branch-based isolation means no expensive full data copies.

    Rollback Wizard
    1

    Preview

    Review impact

    2

    Dependents

    Downstream tables

    3

    Confirm

    Execute rollback

    Rollback Details

    Current:

    70102739706...450

    2026-03-19 17:26

    Target:

    37128451630...510

    2026-03-19 06:05

    11 hours

    Snapshots to Invalidate

    1
    70102739706980974502026-03-19 12:03

    Job Runs to Mark as Rolled Back

    1
    Run IDSnapshotCompleteness Window
    cec2535d7010273970...03-19 06:00 – 12:00

    Instant cascading rollback

    Point-in-time recovery cascades across the full dependency tree automatically. Bad deploy at 2am? One command — all downstream tables included.