| #standardSQL | |
| #################################################################### | |
| # PART 1: Cohort of New Users starting on SEPT 1 | |
| #################################################################### | |
| WITH | |
| new_user_cohort AS ( | |
| SELECT DISTINCT user_pseudo_id as new_user_id | |
| FROM | |
| `projectId.analytics_YOUR_TABLE.events_*` | |
| WHERE |
| /* | |
| * script to export data of the named sheet as an individual csv files | |
| * sheet downloaded to Google Drive and then downloaded as a CSV file | |
| * file named according to the name of the sheet | |
| * original author: Michael Derazon (https://gist.github.com/mderazon/9655893) | |
| */ | |
| function onOpen() { | |
| var ss = SpreadsheetApp.getActiveSpreadsheet(); | |
| var csvMenuEntries = [{name: "Download Primary Time File", functionName: "saveAsCSV"}]; |
| /** | |
| * Fetching data from BigQuery and present it in our sheet | |
| * Author: Ido Green | |
| * Date: 14/12/2013 | |
| * | |
| * See: https://greenido.wordpress.com/2013/12/16/big-query-and-google-spreadsheet-intergration/ | |
| * Misc: https://developers.google.com/bigquery/ | |
| */ | |
| // |
To add a SFTP-only user, you'll need to make sure your SSH config settings are correct, add a new user/group and set permissions for your new user. For step-by-step directions, see below. Omit sudo if you're logged in as root.
Edit /etc/ssh/sshd_config and make sure to add the following at the end of the file:
Match group filetransfer
ChrootDirectory %h