Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
set load scan_rows 10000
drop table strava_activities;
drop table strava_applications;
drop table strava_bikes;
drop table strava_blocks;
drop table strava_clubs;
drop table strava_comments;
drop table strava_components;
drop table strava_connected_apps;
drop table strava_contacts;
drop table strava_email_preferences;
drop table strava_events;
drop table strava_favorites;
drop table strava_flags;
drop table strava_followers;
drop table strava_following;
drop table strava_general_preferences;
drop table strava_global_challenges;
drop table strava_goals;
drop table strava_group_challenges;
drop table strava_kudos;
drop table strava_local_legend_segments;
drop table strava_logins;
drop table strava_memberships;
drop table strava_metering;
drop table strava_mobile_device_identifiers;
drop table strava_monthly_recap_achievements;
drop table strava_orders;
drop table strava_partner_opt_outs;
drop table strava_photos;
drop table strava_posts;
drop table strava_privacy_zones;
drop table strava_profile;
drop table strava_routes;
drop table strava_segment_feedback;
drop table strava_segments;
drop table strava_shoes;
drop table strava_social_settings;
drop table strava_starred_routes;
drop table strava_starred_segments;
drop table strava_support_tickets;
drop table strava_visibility_settings;
load strava_activities activities.csv new
load strava_applications applications.csv new
load strava_bikes bikes.csv new
load strava_blocks blocks.csv new
load strava_clubs clubs.csv new
load strava_comments comments.csv new
load strava_components components.csv new
load strava_connected_apps connected_apps.csv new
load strava_contacts contacts.csv new
load strava_email_preferences email_preferences.csv new
load strava_events events.csv new
load strava_favorites favorites.csv new
load strava_flags flags.csv new
load strava_followers followers.csv new
load strava_following following.csv new
load strava_general_preferences general_preferences.csv new
load strava_global_challenges global_challenges.csv new
load strava_goals goals.csv new
load strava_group_challenges group_challenges.csv new
load strava_kudos kudos.csv new
load strava_local_legend_segments local_legend_segments.csv new
load strava_logins logins.csv new
load strava_memberships memberships.csv new
load strava_metering metering.csv new
load strava_mobile_device_identifiers mobile_device_identifiers.csv new
load strava_monthly_recap_achievements monthly_recap_achievements.csv new
load strava_orders orders.csv new
load strava_partner_opt_outs partner_opt_outs.csv new
load strava_photos photos.csv new
load strava_posts posts.csv new
load strava_privacy_zones privacy_zones.csv new
load strava_profile profile.csv new
load strava_routes routes.csv new
load strava_segment_feedback segment_feedback.csv new
load strava_segments segments.csv new
load strava_shoes shoes.csv new
load strava_social_settings social_settings.csv new
load strava_starred_routes starred_routes.csv new
load strava_starred_segments starred_segments.csv new
load strava_support_tickets support_tickets.csv new
load strava_visibility_settings visibility_settings.csv new
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment