How to write to a specific Google Fusion Table?

The FeatureType (brown thing on the canvas at the right hand end of workspace) has a name, you can edit it by clicking the 'properties' button. With Google Fushion Tables the FeatureType name is the Table name. Your best bet when writing to an existing table is to add the writer first then, Writer > Import FeatureTypes and bring in the schema of the existing table. Then hook up your source, map the attributes and importantly ensure the FeatureType parameters on the Format Parameters Tab have the desired settings for Dropping (destroy and recreate) and Truncating (retain schema but delete all rows) the table.

 

 

Best of luck

Dave I'm not seeing where I "Import Feature Types" for the google fuson table...

 

I added in the writer, specified the feature type name equal to my fusion table name.  Can you tell me how/where do I import feature types to get the schema?

 

Steve

Hmmm, well seems to run with no errors.  I've set the parameters to Truncate Yes.

 

I see the full schema for my fusion table.

 

 

But I get 0 features written and for some reason the inspector opens up with a warning that *** All writer output has been redirected to the Inspector applications ***

 

 

Any other suggestions Dave?  I have 57 features showing as writing to the fusion table, just nothing seems to really be happening on the fusion end..

That's working perfectly now guys!

 

 

Thank you very much for your help - really appreciated!

 

Steve