# Less Documentation ## Docs - [Added Value](https://docs.less.tech/academy/beginner/added-value.md) - [IF all ELSE fails](https://docs.less.tech/academy/beginner/if-all-else-fails.md) - [It's a Date](https://docs.less.tech/academy/beginner/its-a-date.md) - [Join Forces](https://docs.less.tech/academy/beginner/join-forces.md) - [Less to do More](https://docs.less.tech/academy/beginner/less-to-do-more.md) - [Mind Your Language](https://docs.less.tech/academy/beginner/mind-your-language.md) - [Test: Where's the Money](https://docs.less.tech/academy/beginner/wheres-the-money.md) - [Learning Less](https://docs.less.tech/academy/introduction.md): Become a Less expert! - [Audit Log](https://docs.less.tech/admin/audit-log.md): Monitor platform activity - [Credits](https://docs.less.tech/admin/credits.md): Billing overview - [Members](https://docs.less.tech/admin/members.md) - [Notifications](https://docs.less.tech/admin/notifications.md): Get email alerts when connections and models fail - [Platform](https://docs.less.tech/admin/platform.md): Workspace-wide settings - [Roles](https://docs.less.tech/admin/roles.md): Manage workspace roles - [Execute asset](https://docs.less.tech/api-reference/endpoint/executeAsset.md): Queue a run for a source, model, or orchestration - [Get asset](https://docs.less.tech/api-reference/endpoint/getAsset.md): Retrieve basic information about an asset - [Get job status](https://docs.less.tech/api-reference/endpoint/getJob.md): Poll a run started via Execute asset or the app - [Get model (published version)](https://docs.less.tech/api-reference/endpoint/getModel.md): Published model version (full detail) for a model asset - [List assets](https://docs.less.tech/api-reference/endpoint/listAssets.md): List assets you can access - [Get model version](https://docs.less.tech/api-reference/endpoint/modelVersion.md): Fetch one model version including the canvas - [List model versions](https://docs.less.tech/api-reference/endpoint/modelVersions.md): List saved versions for a model - [Introduction](https://docs.less.tech/api-reference/introduction.md): Use the Less API to fetch asset metadata, list model versions, and trigger runs. - [Adding Documentation](https://docs.less.tech/canvas/adding-documentation.md) - [Data Grid](https://docs.less.tech/canvas/datagrid.md): View and interact with your data - [Versions, Draft and Publish](https://docs.less.tech/canvas/draft-publish.md): Saving your work - [Functionality](https://docs.less.tech/canvas/functionality.md) - [Instances and Benchmarking](https://docs.less.tech/canvas/instances.md): Instances determine how much computation power is available for your model or source. - [Parameters](https://docs.less.tech/canvas/parameters.md): A globally available variable store - [Quickstart](https://docs.less.tech/canvas/quickstart.md): Quickstart to the Canvas - [Reserved Conventions](https://docs.less.tech/canvas/reserved.md) - [Storing Data](https://docs.less.tech/canvas/storing-data.md): Two methods for storing data in Canvas. - [Constants](https://docs.less.tech/canvas/syntax-constants.md) - [Functions](https://docs.less.tech/canvas/syntax-functions.md) - [Operations](https://docs.less.tech/canvas/syntax-operations.md) - [Introduction](https://docs.less.tech/canvas/syntax-quickstart.md): Supercharge your tool configuration - [MySQL](https://docs.less.tech/destinations/guides/MySQL.md) - [ClickHouse](https://docs.less.tech/destinations/guides/clickhouse.md) - [Google Sheets](https://docs.less.tech/destinations/guides/googlesheet.md) - [PostgreSQL](https://docs.less.tech/destinations/guides/postgresql.md) - [Snowflake](https://docs.less.tech/destinations/guides/snowflake.md) - [Quickstart](https://docs.less.tech/destinations/quickstart.md): Use Destination to send data elsewhere - [Browse](https://docs.less.tech/essentials/browse.md): Inspect data - [Credits](https://docs.less.tech/essentials/credits.md): How billing works - [Destinations](https://docs.less.tech/essentials/destinations.md): Activate data - [Models](https://docs.less.tech/essentials/models.md): Analyze data - [Orchestrate](https://docs.less.tech/essentials/orchestrate.md): Run models and sources in sequence - [Sources](https://docs.less.tech/essentials/sources.md): Get data - [Inviting Team Members](https://docs.less.tech/guides/inviting-teammembers.md) - [Less IP](https://docs.less.tech/guides/less-ip.md) - [Logs](https://docs.less.tech/guides/logs.md): Monitor your scheduled assets with logs - [Notifications](https://docs.less.tech/guides/notifications.md): Get email alerts - [Abilities](https://docs.less.tech/guides/permissions-abilities.md): An ability enables you to do something on Less - [Groups](https://docs.less.tech/guides/permissions-groups.md): Collections of users - [Quickstart](https://docs.less.tech/guides/permissions-quickstart.md): Get started with permissions in Less - [Roles](https://docs.less.tech/guides/permissions-roles.md): Bundles of abilities - [Setting permissions](https://docs.less.tech/guides/permissions-setting.md): View and create permissions on assets - [Permissions deep dive](https://docs.less.tech/guides/permissions-understanding.md): Deep dive on how permissions work in Less - [Versions](https://docs.less.tech/guides/versions.md): Automatic version control - [Introduction](https://docs.less.tech/introduction.md): Less enables everyone to find insights in every data source. Start solving. - [Quickstart](https://docs.less.tech/quickstart.md): Learn how to use Less in 5 minutes - [ActiveCampaign](https://docs.less.tech/sources/guides/activecampaign.md) - [ClickHouse](https://docs.less.tech/sources/guides/clickhouse.md) - [Dixa](https://docs.less.tech/sources/guides/dixa.md) - [ECB Exchange Rates](https://docs.less.tech/sources/guides/ecb.md) - [e-conomic](https://docs.less.tech/sources/guides/economic.md) - [Files](https://docs.less.tech/sources/guides/files.md) - [Google Ads](https://docs.less.tech/sources/guides/googleads.md) - [Google Analytics (GA4)](https://docs.less.tech/sources/guides/googleanalytics.md) - [Google Sheets](https://docs.less.tech/sources/guides/googlesheets.md) - [HiBob](https://docs.less.tech/sources/guides/hibob.md) - [HubSpot Sales](https://docs.less.tech/sources/guides/hubspot_sales.md) - [ISO Calendar](https://docs.less.tech/sources/guides/iso.md) - [Meta Ads](https://docs.less.tech/sources/guides/metaads.md) - [Microsoft SQL Server (MSSQL)](https://docs.less.tech/sources/guides/mssql.md) - [MySQL](https://docs.less.tech/sources/guides/mysql.md) - [OData](https://docs.less.tech/sources/guides/odata.md) - [PostgreSQL](https://docs.less.tech/sources/guides/postgresql.md) - [SharePoint](https://docs.less.tech/sources/guides/sharepoint.md) - [Snowflake](https://docs.less.tech/sources/guides/snowflake.md) - [WooCommerce](https://docs.less.tech/sources/guides/woocommerce.md) - [Quickstart](https://docs.less.tech/sources/quickstart.md): Use Sources to get your data into Less - [Columns](https://docs.less.tech/tools/basics/columns.md): Select, order, rename and change format of your columns - [Create Rows](https://docs.less.tech/tools/basics/create-rows.md): Create new rows in your dataset - [Destination](https://docs.less.tech/tools/basics/destination.md): Store tables - [Directory](https://docs.less.tech/tools/basics/directory.md): Load multiple tables - [Dynamic Rename](https://docs.less.tech/tools/basics/dynamic-rename.md): Dynamically change your column names - [Fill](https://docs.less.tech/tools/basics/fill.md): Populate NULLs - [Filter](https://docs.less.tech/tools/basics/filter.md): Remove rows with conditions - [Input](https://docs.less.tech/tools/basics/input.md): Load a single table - [Limit](https://docs.less.tech/tools/basics/limit.md): Reduce the number of rows in your data set - [Replace](https://docs.less.tech/tools/basics/replace.md): Replace text values in one or multiple columns - [Save Table](https://docs.less.tech/tools/basics/save-table.md): Store tables in Less - [Sort](https://docs.less.tech/tools/basics/sort.md): Sort the rows in your dataset - [Transform](https://docs.less.tech/tools/basics/transform.md): Change column apparance - [Unique](https://docs.less.tech/tools/basics/unique.md): Remove duplicate rows - [Append](https://docs.less.tech/tools/merge/append.md): Attach a column(s) to another dataset - [Close Combine](https://docs.less.tech/tools/merge/close-combine.md): Merge datasets where IDs almost match - [Combine](https://docs.less.tech/tools/merge/combine.md): Merge datasets horizontally - [Stack](https://docs.less.tech/tools/merge/stack.md): Merge datasets vertically - [Add Business Days](https://docs.less.tech/tools/new-columns/add-business-days.md): Add business days while accounting for holidays - [Compare](https://docs.less.tech/tools/new-columns/compare.md): Move values vertically - [Correlation](https://docs.less.tech/tools/new-columns/correlation.md): Calculate Person and Spearman correlations between two columns - [Count Business Days](https://docs.less.tech/tools/new-columns/count-business-days.md): Add the number of days to two dates while accounting for holidays - [Cumulative](https://docs.less.tech/tools/new-columns/cumulative.md): Create cumulative columns - [Date Difference](https://docs.less.tech/tools/new-columns/date-difference.md): Calculate the difference between date columns in seconds, days, months, etc. - [Date Math](https://docs.less.tech/tools/new-columns/date-math.md): Add or subtract days, seconds, hours and more from date columns - [Date Transform](https://docs.less.tech/tools/new-columns/date-transform.md): Extract part of date columns to new formats - [Explode List](https://docs.less.tech/tools/new-columns/explode-list.md): Extract part of date columns to new formats - [IF Column](https://docs.less.tech/tools/new-columns/if-column.md): Create new columns with conditions - [New Column](https://docs.less.tech/tools/new-columns/new-column.md): Create new columns - [Parse Object](https://docs.less.tech/tools/new-columns/parse-object.md): Parse Objects columns - [Rank](https://docs.less.tech/tools/new-columns/rank.md): Rank values in a column - [Regex](https://docs.less.tech/tools/new-columns/regex.md): Extract text values in one or multiple columns - [Row ID](https://docs.less.tech/tools/new-columns/row-id.md): Create an ID column in your dataset - [Running Interval](https://docs.less.tech/tools/new-columns/running-interval.md): Create custom running calculations - [Split Columns](https://docs.less.tech/tools/new-columns/split-columns.md): Split text columns by delimiters - [String to Date](https://docs.less.tech/tools/new-columns/string-to-date.md): Turn weird date formats into date/datetime formats - [Group By](https://docs.less.tech/tools/reshape/group-by.md): Separate data in groups and perform calculations within those groups - [Pivot](https://docs.less.tech/tools/reshape/pivot.md): Convert rows to columns - [Transpose](https://docs.less.tech/tools/reshape/transpose.md): Convert columns to rows - [API](https://docs.less.tech/tools/utilities/api.md): Call APIs from the Canvas - [Comment](https://docs.less.tech/tools/utilities/comment.md): Add documentation on the Canvas - [Describe](https://docs.less.tech/tools/utilities/describe.md): Metadata about the dataset - [Directions](https://docs.less.tech/tools/utilities/directions.md): Get Distance, Duration and LineString between Two Points - [Flatten JSON](https://docs.less.tech/tools/utilities/flatten-json.md): Flatten a JSON object into a table - [Geocode](https://docs.less.tech/tools/utilities/geocode.md): Get GeoJSON Point and Latitude/Longitude from geographic data - [Group](https://docs.less.tech/tools/utilities/group.md): Containers to structure your Canvas - [Loop](https://docs.less.tech/tools/utilities/loop.md): Loop through the data until a condition is met - [Manual Input](https://docs.less.tech/tools/utilities/manual-input.md): Create data on the Canvas - [Parameter](https://docs.less.tech/tools/utilities/parameter.md): A variable store for reusable values - [Point-in-Polygon](https://docs.less.tech/tools/utilities/point-in-polygon.md): Test if a point is inside an area/polygon - [Polygon](https://docs.less.tech/tools/utilities/polygon.md): Replace text values in one or multiple columns - [Relative Date](https://docs.less.tech/tools/utilities/relative-date.md): Get the current date and time - [Validate](https://docs.less.tech/tools/utilities/validate.md): Create customized warnings ## OpenAPI Specs - [openapi](https://docs.less.tech/api-reference/openapi.json)