Creating Tables
This page guides you through creating table in Cinchy.
You can also find a video walkthrough of table creation on Cinchy TV: https://cinchy.com/all-content/280

Table of Contents

1. Creating a Table from Scratch

  1. 1.
    Navigate to the Cinchy homepage. In the upper left-hand corner, click on Create to get started. (Image 1)
Image 1: Step 1, Getting Started
2. 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 will not be able to create partitions on a spatial table.
  • Standard Table: You cannot create geography or geometry columns in a standard table.
You cannot 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.
Image 2: Step 2, select either a Standard or Spatial Table
3. Select From Scratch (Image 3).
Image 3: Step 3, Select "From Scratch"
4. 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.
Image 4: Step 4, Adding table info.
5. When you are finished with the Info page, select Columns from the left-hand navigation bar (Image 5). See here for additional information about column types.
Image 5: Step 5, Selecting the Columns tab
6. 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
    • Calculated: Data is this column is calculated using a CQL expression
    • Choice: Data entered in this column must be selected from a set of choice answers taht 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 Confidential, Internal, Public, or Restricted
  • Advanced Settings: Select any checkboxes that pertain to your column. See here for more information about these parameters.
You may have further mandatory or optional data to input depending on your selected Data Type.
Image 6: Step 6, defining your column
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 view by view basis. See here for more about data controls and entitlements.
Image 7: Step 7, setting your permissions
8. Click Save to finalize your table.
9. You may return to change the structure of the existing table (i.e. Rename columns, add new columns, change data type) by clicking on the Design Table button on the left-hand navigation (Image 8).
Image 8: Step 9, changing an existing table structure

2. Creating a Table by Importing a CSV

  1. 1.
    Navigate to the Cinchy homepage. In the upper left-hand corner, click on Create to get started (Image 9).
Image 9: Step 1, Getting Started
2. 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 will not be able to create partitions on a spatial table.
  • Standard Table: You cannot create geography or geometry columns in a standard table.
You cannot 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.
Image 10: Step 2, select either a Standard or Spatial Table
3. Select Import a CSV (Image 11).
Image 11: Step 3, Select "Import a CSV"
4. 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: In order to create the table, you must upload a .csv file.
The column names in your .csv file must not conflict with System Columns.
5. When creating a table via Import a CSV, a few 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.
6. To update these settings, navigate to the Design Table tab on the left navigation bar (Image 12).
Image 12: Step 6, Design Table tab

3. Table Views

  1. 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).
Image 13: Step 1: The All Data view
2. You can create additional views by clicking on "+Create View" (Image 14).
Image 14: Step 2, Select "Create View"
3. You may chose to create a view From Scratch or by Copying an Existing view (Image 15).
Image 15: Step 3, Creating a View

From Scratch:

  1. 1.
    Select "From Scratch".
  2. 2.
    The Columns tab will open. Create a Name for your View (Image 16).
  3. 3.
    If you'd like this to become the default view, toggle the default setting to On (Image 16).
Image 16: Steps 2,3
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.
Image 17: Step 4, Selecting Columns
5. Click on the Sort tab in the left navigation bar (Image 18).
Image 18: Step 5, Sorting
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).
Image 19: Step 6, Sorting your view
7. Click on the Filter tab in the left navigation bar. Here, you may use query language to focus your view (Image 20).
Image 20: Step 7, Using the Filter tab
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 is set to All Users (Image 21).
Image 21: Step 8, setting permissions.
9. Select Save to finalize your view.

From Existing:

  1. 1.
    Select "From Existing".
  2. 2.
    Select which view you would like to copy (Image 22).
Image 22: Step 2, Importing a view

Updating a View

  1. 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).
Image 23: Step 1, Updating a View

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.