Overview
This section will include the updated capabilities in Lyftron in the month of September. We have added few features and function along with some connectors. For you more detailed view you can click on the links.
New Features
Some date functions added
Function | Description |
---|---|
DATEADD | Returns a specified date with the specified number interval (signed integer) added to a specified datepart of that date. |
DATEDIFF | Returns the count (signed integer) of the specified datepart boundaries crossed between the specified startdate and enddate. |
DATEFROMPARTS | Returns a date value for the specified year, month, and day. |
New Functionality
A section added to show the Execution Plan Cache screen which will display Execution plan cache provides insights into internal plan cache used by Lyftron. It holds all generated query plans along with steps details and basic execution statistics.
New connectors added
We have added few database connectors in this month.
Function | Description |
---|---|
BigQuery | BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a serverless Software as a Service that supports querying using ANSI SQL. It also has built-in machine learning capabilities. |
Cosmos DB | Azure Cosmos DB is Microsoft's proprietary globally-distributed, multi-model database service "for managing data at planet-scale". It is schema-agnostic, horizontally scalable and generally classified as a NoSQL database. |
Future Releases:
- BigCommerce
- Bing Search
- MongoDB