---
title: "Knack Data Model"
description: "Knack is a low-code platform to build online databases."
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/knack
original: https://documentation.invantive.eu/en/datamodels/knack
updated: 2026-05-19T15:10:48Z
license: https://documentation.invantive.eu/en/
---

# Knack Data Model

Knack is a low-code platform to build online databases.

Authentication
Authentication can be done using one of the following two alternatives:
1. Using the user log on code and password to access Knack views.
2. Using an API key to access Knack objects.
The API key can be found on the 'API & Code' page in Knack available through the settings gear on the top-left corner next to the word 'Integration'. The URL for the API key is https://builder.knack.com/SAMPLE/integration#settings/api, with 'SAMPLE' replaced by your slug. The slug is the word before 'knack.com' when running your app.

Usage Limits
Invantive SQL executes API calls to retrieve and upload data. The number of API calls allowed per hour depends on your Knack plan. The default usage limits vary depending on plan between 1.000 and 25.000 calls per day, with a limit of 10 calls per second. Invantive SQL ensures that within your session the number of calls allowed per hour is not exceeded.
To get an impression of how Invantive SQL translates into API calls, please query the data dictionary view 'sessionios', such as with 'select * from sessionios@datadictionary'.

Set up this platform in Invantive Cloud: https://cloud.invantive.com/knack

Text comparisons on this platform are case sensitive.

## Platform

- Used from: Invantive Cloud and the Invantive products on your own computer or server.
- Kind: an application reached over its API.
- The data is partitioned, such as per company or administration.
- Data can be written as well as read.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Status of the platform: [https://status.knack.com/](https://status.knack.com/).
- Language of its user community: English.

## Figures

| Figure | Count |
|---|---:|
| Tables | 45 |
| Columns | 1,257 |

## Tables

### Knack.DataDictionary

- [ApplicationById](Knack.DataDictionary.ApplicationById): Application by ID
- [Applications](Knack.DataDictionary.Applications): Applications
- [ObjectFieldValidations](Knack.DataDictionary.ObjectFieldValidations): Knack Field Validations
- [ObjectFieldValidationsByApplicationId](Knack.DataDictionary.ObjectFieldValidationsByApplicationId): Knack Field Validations by Application ID
- [ObjectFields](Knack.DataDictionary.ObjectFields): Knack Object Fields
- [ObjectFieldsByApplicationId](Knack.DataDictionary.ObjectFieldsByApplicationId): Knack Object Fields by Application ID
- [ObjectInboundConnections](Knack.DataDictionary.ObjectInboundConnections): Knack Object Inbound Connections
- [ObjectInboundConnectionsByApplicationId](Knack.DataDictionary.ObjectInboundConnectionsByApplicationId): Knack Object Inbound Connections by Application ID
- [ObjectOutboundConnections](Knack.DataDictionary.ObjectOutboundConnections): Knack Object Outbound Connections
- [ObjectOutboundConnectionsByApplicationId](Knack.DataDictionary.ObjectOutboundConnectionsByApplicationId): Knack Object Outbound Connections by Application ID
- [ObjectRuleCriteria](Knack.DataDictionary.ObjectRuleCriteria): Knack Object Rule Criteria
- [ObjectRuleCriteriaByApplicationId](Knack.DataDictionary.ObjectRuleCriteriaByApplicationId): Knack Object Rule Criteria by Application ID
- [ObjectRuleValues](Knack.DataDictionary.ObjectRuleValues): Knack Object Rule Values
- [ObjectRuleValuesByApplicationId](Knack.DataDictionary.ObjectRuleValuesByApplicationId): Knack Object Rule Values by Application ID
- [ObjectRules](Knack.DataDictionary.ObjectRules): Knack Object Rules
- [ObjectRulesByApplicationId](Knack.DataDictionary.ObjectRulesByApplicationId): Knack Object Rules by Application ID
- [Objects](Knack.DataDictionary.Objects): Knack Objects
- [ObjectsByApplicationId](Knack.DataDictionary.ObjectsByApplicationId): Knack Objects by Application ID
- [SceneViews](Knack.DataDictionary.SceneViews): Knack Scene Views
- [SceneViewsByApplicationId](Knack.DataDictionary.SceneViewsByApplicationId): Knack Scene Views by Application ID
- [Scenes](Knack.DataDictionary.Scenes): Knack Scenes
- [ScenesByApplicationId](Knack.DataDictionary.ScenesByApplicationId): Knack Scenes by Application ID

### Knack.Journal_Details

- [Journal_DetailsById](Knack.Journal_Details.Journal_DetailsById)

### Knack.Journals

- [Journals](Knack.Journals.Journals): Table

### Knack.Native

- [NATIVEPLATFORMSCALARREQUESTS](Knack.Native.NATIVEPLATFORMSCALARREQUESTS): Native Platform Scalar Requests

### Knack.Objects

- [A_B_C](Knack.Objects.A_B_C): A B Cs
- [Accounts](Knack.Objects.Accounts): Accounts
- [Companies](Knack.Objects.Companies): Companies
- [CompaniesExpanded](Knack.Objects.CompaniesExpanded): Companies
- [Contacts](Knack.Objects.Contacts): Contacts
- [ContactsExpanded](Knack.Objects.ContactsExpanded): Contacts
- [DateTest](Knack.Objects.DateTest): DateTests
- [Journals](Knack.Objects.Journals): Journals
- [JournalsMultiple_Choice](Knack.Objects.JournalsMultiple_Choice): Multiple choices for Journals
- [OrdersObject](Knack.Objects.OrdersObject): OrdersObjects
- [Payments](Knack.Objects.Payments): Payments
- [Products](Knack.Objects.Products): Products
- [ProductsExpanded](Knack.Objects.ProductsExpanded): Products
- [Test](Knack.Objects.Test): Tests
- [TestExpanded](Knack.Objects.TestExpanded): Tests
- [TestcaseIUD](Knack.Objects.TestcaseIUD): TestcaseIUDs
- [TestcaseIUDExpanded](Knack.Objects.TestcaseIUDExpanded): TestcaseIUDs
- [testpho](Knack.Objects.testpho): testphos

### Knack.Product_Details

- [Product_DetailsById](Knack.Product_Details.Product_DetailsById)

### Knack.ProductsMenu

- [Products](Knack.ProductsMenu.Products): Table

## Attributes

The attributes of this platform are on the page [Attributes](attributes).



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Knack](/en/release-notes/drivers?driver=knack)

