by Uri Bushey, on October 24, 2023
We're thrilled to introduce the Narrative Query Language (NQL)—a groundbreaking SQL interface that transforms your data experience on the Narrative Platform. Combined with our Rosetta Stone Attribute Catalog, NQL lets you query shareable or purchasable data from across the entire ecosystem as if it's all housed in your own database. Say goodbye to data silos and hello to limitless insights!
What is NQL?
NQL is designed to work seamlessly with the existing architecture of the Narrative Data Collaboration Platform. It allows you to query data in a streamlined and intuitive manner, empowering both seasoned data scientists and SQL newcomers to derive meaningful insights from their data and the marketplace of datasets with ease.
Rosetta Stone Attribute Catalog
One of NQL's standout features is its integration with the Rosetta Stone global attribute catalog. This catalog serves as a central repository for normalized data attributes, aggregated from multiple sources across any company on the platform that has set up an Access Rule. Whether you're querying data from your own company or another that has granted you access, the Rosetta Stone catalog simplifies your data querying process.
Understanding Normalization with Rosetta Stone Attributes
Different data sources often label things differently. For example, one might use 'M' or 'F' to indicate gender, while another uses true/false values. Rosetta Stone's universal translator makes sure everyone's speaking the same language, so you don't have to worry about it.
The Magic of Rosetta Stone Attributes
Narrative's Rosetta Stone Attribute technology are what really sets NQL apart. Imagine querying data from multiple organizations as if it all lives in your own table, normalized and ready for analysis. No need to juggle different formats or schemas. Rosetta Stone Attributes make it seamless.
Example: Querying Rosetta Stone Attributes in NQL
To showcase the power of NQL, let's execute a query that filters data sourced from multiple suppliers on the platform based on gender and a specific event timestamp, while also considering cost control.
In this query, we:
Rosetta offers a plethora of benefits. Here are several that stand out:
- Use `EXPLAIN` to forecast the query's cost and data.
- Select the "unique_id" and "gender" attributes from the narrative.rosetta_stone table, which represents any dataset on the platform that has been mapped to these attributes.
- Filter the results to include only records with a gender value of 'female'.
- Further filter by events that occurred after October 1, 2023.
- Limit cost by specifying a maximum CPM of 2.0 USD.
By leveraging Rosetta Stone Attributes, we can streamline complex queries and make data collaboration simple and efficient.
