Launch HN: Baselit (YC W23) – Automatically Reduce Snowflake Costs

Re:Launch HN: Baselit (YC W23) – Automatically Reduce Snowfl... by redwood on Thursday May 09, 2024 @06:15AM (#40306737)

Can you clarify what you mean by "they're really good at writing semantic layer queries"?

Re JSON query format: you mean that's what you're using?

[ Parent | on HN ]

Re:Launch HN: Baselit (YC W23) – Automatically Reduce Snowfl... by mritchie712 on Thursday May 09, 2024 @10:36AM (#40308671)

Yes, the queries for the semantic layer we're using are in JSON. Here's an example query:

    {
      "measures": ["stories.count"],
      "dimensions": ["stories.category"],
      "filters": [
        {
          "member": "stories.isDraft",
          "operator": "equals",
          "values": ["No"]
        }
      ],
      "timeDimensions": [
        {
          "dimension": "stories.time",
          "dateRange": ["2015-01-01", "2015-12-31"],
          "granularity": "month"
        }
      ],
      "limit": 100,
      "offset": 50,
      "order": {
        "stories.time": "asc",
        "stories.count": "desc"
      },
      "timezone": "America/Los_Angeles"
    }

[ Parent | on HN ]