topic Re: Create a custom task like a query builder in SAS Enterprise Guide

Create a custom task like a query builder

hogego — Thu, 18 Oct 2018 08:15:25 GMT

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.

Re: Create a custom task like a query builder

Patrick — Thu, 18 Oct 2018 09:20:16 GMT

@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.

Re: Create a custom task like a query builder

ChrisHemedinger — Thu, 18 Oct 2018 12:42:41 GMT

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

Re: Create a custom task like a query builder

TomKari — Thu, 18 Oct 2018 15:51:44 GMT

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

Re: Create a custom task like a query builder

hogego — Mon, 22 Oct 2018 10:33:46 GMT

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.