Query Athena in Slack
 {
for (var _len = arguments.length, macroArgs = new Array(_len), _key = 0; _key < _len; _key++) {
macroArgs[_key] = arguments[_key];
}
var argCount = numArgs(macroArgs);
var args;
var kwargs = getKeywordArgs(macroArgs);
if (argCount > argNames.length) {
args = macroArgs.slice(0, argNames.length); // Positional arguments that should be passed in as
// keyword arguments (essentially default values)
macroArgs.slice(args.length, argCount).forEach(function (val, i) {
if (i < kwargNames.length) {
kwargs[kwargNames[i]] = val;
}
});
args.push(kwargs);
} else if (argCount < argNames.length) {
args = macroArgs.slice(0, argCount);
for (var i = argCount; i < argNames.length; i++) {
var arg = argNames[i]; // Keyword arguments that should be passed as
// positional arguments, i.e. the caller explicitly
// used the name of a positional arg
args.push(kwargs[arg]);
delete kwargs[arg];
}
args.push(kwargs);
} else {
args = macroArgs;
}
return func.apply(_this, args);
}){kind=icon}
Query Athena from Slack commands
This app allows you to run Athena queries from Slack using dynamic tasks. Dynamic tasks is a feature that allows users to programmatically create and destroy scheduled tasks from Transposit operations. Read more about this feature in our documentation
Example: /athena select * from [database_name] limit 10
When an user sends queries like above via Slack, a Transposit webhook gets invoked, sends a query request to Athena, then creates a scheduled task to check on query status every 5s. The webhook will post back to Slack once results become available.
Test against your own infrastructure#
Step 0: Fork this app
Step 1: Set up Slack slash command
Go to api.slack.com, select Your Apps, then navigate to your app of choice to set up.
Click on Slack Commands on the left, then Create New Command.
In the Request URL field, enter the url you find in Transposit UI: Deploy -> Endpoints -> Webhook under 'cURL'
Enter command name of your choice for Command field
Step 2:
Make sure the app you just configured is installed, then navigate to Slack, type
/command_name select * from database_name