5️⃣
Cinchy Platform Documentation
Cinchy v5.8
Cinchy v5.8
  • Data Collaboration Overview
  • Release notes
    • Release notes
      • 5.9 release notes
      • 5.8 Release Notes
      • 5.7 Release Notes
      • 5.6 Release Notes
      • 5.5 Release Notes
      • 5.4 Release Notes
      • 5.3 Release Notes
      • 5.2 Release Notes
      • 5.1 Release Notes
      • 5.0 Release Notes
  • Support
  • Glossary
  • FAQ
  • Deployment guide
    • Deploying Cinchy
      • Plan your deployment
        • Deployment architecture
          • Kubernetes architecture
          • IIS architecture
        • Deployment prerequisites
          • Single Sign-On (SSO) integration
            • Enable TLS 1.2
            • Configure ADFS
            • AD Group Integration
      • Kubernetes
        • Disable your Kubernetes applications
        • Change your file storage configuration
        • Configure AWS IAM for Connections
        • Use Self-Signed SSL Certs (Kubernetes)
        • Deploy the CLI (Kubernetes)
      • IIS
  • Upgrade guide
    • Upgrade Cinchy
      • Cinchy Upgrade Utility
      • Kubernetes upgrades
        • v5.1 (Kubernetes)
        • v5.2 (Kubernetes)
        • v5.3 (Kubernetes)
        • v5.4 (Kubernetes)
        • v5.5 (Kubernetes)
        • v5.6 (Kubernetes)
        • v5.7 (Kubernetes)
        • v5.8 (Kubernetes)
        • Upgrade AWS EKS Kubernetes version
        • Update the Kubernetes Image Registry
        • Upgrade Azure Kubernetes Service (AKS)
      • IIS upgrades
        • v4.21 (IIS)
        • v4.x to v5.x (IIS)
        • v5.1 (IIS)
        • v5.2 (IIS)
        • v5.3 (IIS)
        • v5.4 (IIS)
        • v5.5 (IIS)
        • v5.6 (IIS)
        • v5.7 (IIS)
        • v5.8 (IIS)
      • Upgrading from v4 to v5
  • Guides for using Cinchy
    • User Guide
      • Data Browser overview
      • The Admin panel
      • User preferences
        • Personal access tokens
      • Table features
      • Data management
      • Queries
      • Version management
        • Versioning best practices
      • Commentary
    • Builder Guide
      • Best practices
      • Create tables
        • Attach files
        • Columns
        • Data controls
          • Data entitlements
          • Data erasure
          • Data compression
        • Formatting rules
        • Indexing & partitioning
        • Linking data
        • Table and column GUIDs
        • System tables
      • Delete tables
        • Restore tables, columns, and rows
      • Saved queries
      • CinchyDXD
        • Overview
        • DXD workflow
        • Package the data experience
        • Install the data experience
        • Release package
        • Changelog
        • References
          • Cinchy DXD CLI reference
          • Data Experience Definitions table
          • Data Experience Reference table
      • Multilingual support
      • Integration guides
    • Administrator Guide
    • Additional guides
      • Monitor and Log on Kubernetes
        • Grafana
        • OpenSearch dashboards
          • Set up Alerts
        • Monitor via ArgoCD
      • Maintenance
      • Cinchy Secrets Manager
      • GraphQL (Beta)
      • System properties
      • Enable Data At Rest Encryption (DARE)
      • Application experiences
        • Network map
          • Custom node results
          • Custom results in the Network Map
        • Set up experiences
  • API Guide
    • API overview
      • API authentication
      • API saved queries
      • ExecuteCQL
      • Webhook ingestion
  • CQL
    • Overview
      • CQL examples
      • CQL statements overview
        • Cinchy DML statements
        • Cinchy DDL statements
      • Cinchy supported functions
        • Cinchy functions
        • Cinchy system values
        • Cinchy User Defined Functions (UDFs)
          • Table-valued functions
          • Scalar-valued functions
        • Conversion functions
        • Date and Time types and functions
          • Return System Date and Time values
          • Return Date and Time parts
          • Return Date and Time values from their parts
          • Return Date and Time difference values
          • Modify Date and Time values
          • Validate Date and Time values
        • Logical functions
        • Math functions
        • String functions
        • Geometry and Geography data type and functions
          • OGC methods on Geometry & Geography instances
          • Extended methods on Geometry & Geography instances
        • Full Text Search functions
        • Connections functions
        • JSON functions
    • CQL functions reference list
  • Meta-Forms
    • Introduction
    • Install Meta-Forms
      • Deploy Meta-Forms (Kubernetes)
      • Deploy Meta-Forms (IIS)
    • Forms data types
    • Meta-Forms Builder Guide
      • Create a dynamic meta-form with tables
      • Create a dynamic meta-form example with Form Designer
      • Add links to a form
      • Rich text editing in forms
  • Data syncs
    • Get started with data syncs
    • IIS installation
      • Install Connections
      • Install the Worker/Listener
      • Install the Connections CLI
    • Build data syncs
      • Data sync types
      • Design patterns
      • Sync actions
      • Columns and mappings
        • Calculated column examples
      • Advanced settings
        • Filters
        • Variables
        • Auth requests
        • Request headers
        • Post sync scripts
        • Pagination
      • Batch data sync example
      • Real-time sync example
      • Schedule a data sync
      • Connection functions
    • Data sync sources
      • Cinchy Event Broker/CDC
        • Cinchy Event Broker/CDC XML config example
      • Cinchy Table
        • Cinchy Table XML config example
      • Cinchy Query
        • Cinchy Query XML config example
      • Copper
      • DB2 (query and table)
      • Dynamics 2015
      • Dynamics
      • DynamoDB
      • File-based sources
        • Binary file
        • Delimited file
        • Excel
        • Fixed width file
        • Parquet
      • Kafka Topic
        • Kafka Topic example config
        • Apache AVRO data format
      • LDAP
      • MongoDB collection
        • MongoDB collection source example
      • Mongo event
      • MongoDB collection (Cinchy event)
      • MS SQL Server (query and table)
      • ODBC Query
      • Oracle (query and table)
      • Polling event
        • Polling event example config
      • REST API
      • REST API (Cinchy event)
      • SAP SuccessFactors
      • Salesforce Object (Bulk API)
      • Salesforce platform event
      • Salesforce push topic
      • Snowflake
        • Snowflake source example config
      • SOAP 1.2 web service
      • SOAP 1.2 web service (Cinchy Event Triggered)
    • Data sync destinations
      • Cinchy Table
      • DB2 table
      • Dynamics
      • Kafka Topic
      • MongoDB collection
      • MS SQL Server table
      • Oracle table
      • REST API
      • Salesforce
      • Snowflake table
      • SOAP 1.2 web service
    • Real-time sync stream sources
      • The Listener Config table
      • Cinchy Event Broker/CDC
      • Data Polling
      • Kafka Topic
      • MongoDB
      • Salesforce Push Topic
      • Salesforce Platform Event
    • CLI commands list
    • Troubleshooting
  • Other Resources
    • Angular SDK
    • JavaScript SQK
Powered by GitBook
On this page
  • Create a table from scratch
  • Import a CSV to create a table
  • Table views
  • From Scratch:
  • From Existing
  • Updating a view
  • 4. Bookmarks and the Homepage
  1. Guides for using Cinchy
  2. Builder Guide

Create tables

This page guides you through creating table in Cinchy.

PreviousBest practicesNextAttach files

Last updated 1 year ago

Create a table from scratch

  1. Navigate to the Cinchy homepage. In the upper left-hand corner, click on Create to get started. (Image 1)

  1. Select either a Standard or a Spatial Table (Image 2), per the descriptions below.

  • Spatial Table: A spatial table allows you to create geography and geometry column types, as well as geospatial indexes. You won't be able to create partitions on a spatial table.

  • Standard Table: You can't create geography or geometry columns in a standard table.

You can't convert from one type to another and will have to either recreate your table or link to another table with geospatial columns.

Any existing tables created before installing Cinchy Platform v4.19.0 are standard tables.

  1. Select From Scratch (Image 3).

  1. A new page will open with the Table Info tab (Image 4). Input the following information:

  • Table Name: This is a mandatory field, and must be unique to the domain you select.

  • Icon: You can pick an icon and colour to differentiate your table on thee home screen.

  • Domain: This is a mandatory field. Select the domain that this table will reside under. If you are have administrative privileges, you can also create new domains from this screen.

  • Description: You can give your table a description, which will be displayed on the homepage.

  1. A new page will open with the Columns tab (Image 6). Every table in Cinchy must have at least one column. Input the following information:

  • Column Name: Input a unique column name.

  • Data Type: You can select from the following:

    • Text: All data in this column must be input as text

    • Number: All data in this column must be input numerically

    • Date: All data in this column must be in date format. The default is yyyy-mm-dd however you can change that.

    • Yes/No: All data in this column must be in Yes/No format

    • Choice: Data entered in this column must be selected from a set of choice answers that you provide

    • Link: Data in a link column is pulled from elsewhere on Cinchy

  • Description: Enter a description of your column

  • Data Security Classification: You can select from Public, Internal, Confidential, or Restricted. Additional options can be created in the [Cinchy].[Data Security Classifications] table by an Administrator.

    • Restricted: Restricted data is the most sensitive data, so you would have to treat it extra carefully. If compromised or accessed without authorization, it could lead to criminal charges, massive legal fines, or cause irreparable damage to the company. Examples include intellectual property, proprietary information or data protected by state and federal regulations.

    • Confidential: Often, access to confidential data requires additional authorization and explanation of why access to the data is needed. Examples of confidential data include social security numbers, credit card details, phone numbers or medical records. Depending on the industry, confidential data is protected by laws like GDPR, HIPAA, CASL and others.

    • Internal: This type of data is strictly accessible to internal company personnel or employees who are granted access. This might include internal-only memos, business performance, customer surveys or website analytics.

    • Public: This type of data is freely accessible to all employees and company personnel. It can be freely used, reused, and redistributed without repercussions. An example might be job descriptions, press releases or links to articles.

Currently there is no functionality tied directly to Data Security Classification - the tagging is just for internal auditing purposes. Future security settings will be tied to Data Security Classifications, rather than simply done at a column level.

You may have further mandatory or optional data to input depending on your selected Data Type.

  1. Click Save to finalize your table.

  2. You may return to change the structure of the existing table (such as rename columns, add new columns, change data type) by clicking on the Design Table button on the left-hand navigation (Image 8).

Import a CSV to create a table

  1. Navigate to the Cinchy homepage. In the upper left-hand corner, click on Create to get started (Image 9).

  1. Select either a Standard or a Spatial Table (Image 10), per the descriptions below.

  • Spatial Table: A spatial table allows you to create geography and geometry column types, as well as geospatial indexes. You won't be able to create partitions on a spatial table.

  • Standard Table: You can't create geography or geometry columns in a standard table.

You can't convert from one type to another and will have to either recreate your table or link to another table with geospatial columns.

Any existing tables created before installing Cinchy Platform v4.19.0 are standard tables.

  1. Select Import a CSV (Image 11).

  1. Enter the following information:

  • Domain: Select the domain that you table will reside under. If you are have administrative privileges, you can also create new domains from this screen.

  • File: To create the table, you must upload a .csv file.

  1. When creating a table via Import a CSV, some settings will be set by default:

  • Default Table Name: The name of the file will be used as the name of the table (a number will be appended if there is a duplicate - ex. uploading Teams.csv will create a table named Teams 1, then Team 2 if uploaded again). You can always rename the table after it has been created.

  • Default Table Icon: The icon defaults to a green paintbrush.

  • Default Column Types: Columns by default will be created as a text field, with a maximum length of the longest value in the column. If a column has only numeric values in it, it will be created as a numeric column.

  1. To update these settings, navigate to the Design Table tab on the left navigation bar (Image 12).

Table views

  1. When you first create a table, a default view called All Data will be created for you, which you can find on the left navigation bar under Manage Data (Image 13).

  1. You can create additional views by clicking on "+Create View" (Image 14).

  1. You may chose to create a view From Scratch or by Copying an Existing view (Image 15).

From Scratch:

  1. Select From Scratch.

  2. The Columns tab will open. Create a Name for your View (Image 16).

  3. If you'd like this to become the default view, toggle the default setting to On (Image 16).

4. Select the column(s) that you want to be visible in this view (Image 17). You may rearrange the column order using drag and drop.

5. Click on the Sort tab in the left navigation bar (Image 18).

6. Use this screen to select which columns you'd like to sort your data by, and in which order. You may rearrange the columns using drag and drop (Image 19).

8. Click on the Permission tab in the left navigation bar. Here, you may set permissions for who can use this view. By default, it's set to All Users (Image 21).

9. Select Save to finalize your view.

From Existing

  1. Select From Existing.

  2. Select which view you would like to copy (Image 22).

Updating a view

  1. To update any view, including the Add Data view, click on the pencil icon next to the view's name under Manage Data (Image 23).

4. Bookmarks and the Homepage

Once you create a table, it will be added to your bookmarks by default. Other users (or if you un-star the table from your bookmarks) will see it in the Homepage if they have permissions to.

When you are finished with the Info page, select Columns from the left-hand navigation bar (Image 5). for additional information about column types.

Calculated: Data is this column is calculated using a expression

Advanced Settings: Select any checkboxes that pertain to your column. for more information about these parameters.

7. Click on Design Controls > Entitlements in the left navigation pane to set your permissions (Image 7). You may set these as granular as you choose. You may also set permissions on a

The column names in your .csv file must not conflict with

7. Click on the Filter tab in the left navigation bar. Here, you may use to focus your view (Image 20).

See here
CQL
Watch the Cinchy TV episode on Data Types here.
query language
See here for more about data controls and entitlements.
view by view basis.
See here
System Columns.
Image 1: Step 1, Getting Started
Image 2: Step 2, select either a Standard or Spatial Table
Image 3: Step 3, Select "From Scratch"
Image 4: Step 4, Adding table info.
Image 5: Step 5, Selecting the Columns tab
Image 6: Step 6, defining your column
Image 7: Step 7, setting your permissions
Image 8: Step 9, changing an existing table structure
Image 9: Step 1, Getting Started
Image 10: Step 2, select either a Standard or Spatial Table
Image 11: Step 3, Select "Import a CSV"
Image 12: Step 6, Design Table tab
Image 13: Step 1: The All Data view
Image 14: Step 2, Select "Create View"
Image 15: Step 3, Creating a View
Image 16: Steps 2,3
Image 17: Step 4, Selecting Columns
Image 18: Step 5, Sorting
Image 19: Step 6, Sorting your view
Image 20: Step 7, Using the Filter tab
Image 21: Step 8, setting permissions.
Image 22: Step 2, Importing a view
Image 23: Step 1, Updating a View