Supernova home
Documentation menu

Canny#

Connect Canny with an API key. The source writes 8 fixed tables under titan.canny.

sql
select
  id,
  name,
  created
from titan.canny.boards
limit 10

Connect Canny#

  1. Open Apps, choose Connect app, and select Canny.

  2. Enter an API key.

  3. Review the tables, then save the source.

  4. Watch Sync history until the first run completes.

Credentials are stored as secrets. They never become lake columns or appear in query results.

Sync behavior#

Boards, posts, votes, comments, users, changelog entries, tags, and status changes sync together.

A new source syncs when you connect it and then follows its schedule. The default recurring interval is 4 hours. An interrupted run keeps its completed progress and retries safely.

Every lake table also has the system columns _synced_at and _deleted; the column reference below lists source columns only.

Table reference#

boards#

titan.canny.boards has 5 source columns.

canny.boards5 columns
idstringpk

Source field id.

namestring

Source field name.

createddatetime

Source field created.

urlstring

Source field url.

post_countinteger

Source field postCount.

posts#

titan.canny.posts has 9 source columns.

canny.posts9 columns
idstringpk

Source field id.

titlestring

Source field title.

detailsstring

Source field details.

statusstring

Source field status.

scoreinteger

Source field score.

comment_countinteger

Source field commentCount.

author_idstring

Source field authorID.

board_idstring

Source field boardID.

createddatetime

Source field created.

votes#

titan.canny.votes has 4 source columns.

canny.votes4 columns
idstringpk

Source field id.

post_idstring

Source field postID.

voter_idstring

Source field voterID.

createddatetime

Source field created.

comments#

titan.canny.comments has 5 source columns.

canny.comments5 columns
idstringpk

Source field id.

post_idstring

Source field postID.

author_idstring

Source field authorID.

valuestring

Source field value.

createddatetime

Source field created.

users#

titan.canny.users has 5 source columns.

canny.users5 columns
idstringpk

Source field id.

namestring

Source field name.

emailstring

Source field email.

createddatetime

Source field created.

user_idstring

Source field userID.

changelog_entries#

titan.canny.changelog_entries has 4 source columns.

canny.changelog_entries4 columns
idstringpk

Source field id.

titlestring

Source field title.

statusstring

Source field status.

published_atdatetime

Source field publishedAt.

tags#

titan.canny.tags has 4 source columns.

canny.tags4 columns
idstringpk

Source field id.

namestring

Source field name.

board_idstring

Source field boardID.

createddatetime

Source field created.

status_changes#

titan.canny.status_changes has 5 source columns.

canny.status_changes5 columns
idstringpk

Source field id.

post_idstring

Source field postID.

statusstring

Source field status.

changer_idstring

Source field changerID.

createddatetime

Source field created.

Deletes and history#

Rows are merged by their source key. When the source can prove that a row was deleted, Supernova keeps the row and sets _deleted so queries can choose whether to include history. Filter current-state queries with where not _deleted.