SAS Enterprise Guide

Desktop productivity for business analysts and programmers
BookmarkSubscribeRSS Feed
hogego
Calcite | Level 5

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.

4 REPLIES 4
Patrick
Opal | Level 21

@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
Community Manager

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

Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!
hogego
Calcite | Level 5

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
Onyx | Level 15

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

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1636 views
  • 0 likes
  • 4 in conversation