Create a custom task like a query builder

[hogego]

Hi.

I'm working on a custom task.

Because the customer wants to do an operation to throw a query to BigQuery.

Although we are considering offering by custom task, we are thinking whether Query Builder parts can be used.
Is it possible to use a query builder form such as "join" or "filter" for custom tasks?

Thanks.

Takahashi.

[Patrick]

@hogego

The master for this topic is certainly @ChrisHemedinger.

If you search using keywords plus his name then you'll find a lot of material which might give you direction on how to go about this.

[ChrisHemedinger]

Hi @hogego,

Unfortunately, none of the built-in query components (join, filter, etc) are available as standalone pieces for use in custom tasks.

However, if you have SAS/ACCESS to ODBC you may be able to use the EG Query Builder to pull data from BigQuery.  BigQuery does support an ODBC connection, and this might work for simple queries.  I confess I haven't tried that, but others have discussed this approach on the communities here.

Chris

[hogego]

Hi Chris.

Thank you for your reply.
By the way I bought your book.:)

Yes, I confirmed that data can be acquired by ODBC connection.
However, due to constraints on insertion, it was not possible to populate the Bigquery with data in the Query Builder.
Google has constraints on the number and frequency of insertions and restrictions on Access to ODBC as DBIDIRECTEXEC and BULKLOAD can not be used.

I would like to create a range possible with standard parts.

I wish I could add a table...

Thanks.

[TomKari]

Another possible option is to use SAS Studio. In my opinion, the custom task functionality is easier to use but less powerful in Studio.

Tom