How are tasks tied to projects?

singer-io / tap-asana

Singer.io tap for extracting Asana data

GNU Affero General Public License v3.0

7 stars 20 forks source link

How are tasks tied to projects? #15

Closed rohansahai closed 4 years ago

rohansahai commented 4 years ago

I'm using a stitch connector that uses this code to dump data from asana into redshift. I end up with a tasks__projects table that just has a guid column and a resource_type column. With just those two columns i don't see how the table relates a task to a project?

I'm new to singer/stitch so apologize if this question is in the wrong place.

rohansahai commented 4 years ago

Hmm nvm, looks like stitch is auto creating these tables or something because one of their system columns (sdc_source_key_id) is what I was looking for.