Query and retrieve data faster with reusable variables
A variable is a value that stores information to be referenced. In Resmo, variables enable you to define static or dynamic constructs to be used in your SQL queries.
Some use cases in Resmo required writing longer queries manually or spending more time on forming queries unique to your business each time you need. Now, variables provide a solution by allowing you to write reusable queries faster.
Once you define a variable with the correct type and value, it will be suggested in autocomplete when you are typing a query. For example, after defining a user variable, you can type $user to refer to that construct in your queries.
- String Array
- Number Array
- SQL Query
Variables reduce the time spent typing queries with values unique to your business. They allow you to create reusable constructs and retrieve data faster.
Some common values that are better suited for variables rather than literal values include:
- User list
- ie. list of users in your company as a static array or refer to Google Workspace or Okta users as your directory to check against any unwanted user registration in any of your tools.
- Domain names
- Email list
- ie. data retention
- Long re-used SQL queries
- Other long values such as long URLs
- 1.Log in to your Resmo account and navigate to Settings>Variables.
2. Click the Add Variable button from the top right.
3. Give a descriptive name to it, one that you will remember when typing your SQL query.
4. Next, select a variable type such as string, boolean, or number.
5. Finally, enter a variable value in the related field.
6. Hit the create button, and now your variable is all set. You can find your created variables on the Variables page.
7. To see if it's properly working, go to the Search page and type a query that includes the variable.
- See GitHub admin users who are not on your Gsuite users list:
SELECT VALUE primaryEmail FROM gsuite_user
SELECT * FROM github_org_member WHERE role = 'admin' and user.email NOT IN $users['email']
- Check if Cloudflare proxies your domain/s:
SELECT * FROM cloudflare_zone_dnsrecord WHERE zone_name = $DomainName and proxied
- Search for AWS EC2 instances in predefined regions:
$allowedRegion = [“us-west2”,”us-east-1”]
SELECT * FROM aws_ec2_instance WHERE region IN $allowedRegion